• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Mysql query

 
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am new to mysql, please can anyone explain me the below line

KEY `aircraft_model_code` (`aircraft_model_code`)

There are two tables created which are as follows.








 
Marshal
Posts: 79177
377
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Are you sure that KEY on its own, rather than FOREIGN KEY and PRIMARY KEY, is correct MySQL syntax?
 
Sapan Shah
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes I am sure,

A MySQL dump of the modified database can be found at this book's website: http://www.packtpub.com/support.
The FlightStats database uses the default MyISAM MySQL engine, which does not support referential integrity (foreign keys).

When going to the above website the select option will be shown ,in which different books name are there.

Kindly select JasperReports for Java Developers.

Then enter your email address to download the zip file.After downloading zip file you will get flightstats_myisam.sql file
in which the mysql queries are writtren.
 
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I suppose it is same as index.

http://dev.mysql.com/doc/refman/5.1/en/create-table.html
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic