This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Mysql query

 
Sapan Shah
Greenhorn
Posts: 25
  • Mark post as helpful
  • send pies
  • 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.








 
Campbell Ritchie
Sheriff
Pie
Posts: 50245
79
  • Mark post as helpful
  • send pies
  • 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
  • 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.
 
Fatih Keles
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I suppose it is same as index.

http://dev.mysql.com/doc/refman/5.1/en/create-table.html
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic