Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Mysql query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Mysql query" Watch "Mysql query" New topic
Author

Mysql query

Sapan Shah
Greenhorn

Joined: Jan 01, 2010
Posts: 25
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

Joined: Oct 13, 2005
Posts: 36508
    
  16
Are you sure that KEY on its own, rather than FOREIGN KEY and PRIMARY KEY, is correct MySQL syntax?
Sapan Shah
Greenhorn

Joined: Jan 01, 2010
Posts: 25
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

Joined: Sep 01, 2005
Posts: 182
I suppose it is same as index.

http://dev.mysql.com/doc/refman/5.1/en/create-table.html
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Mysql query
 
Similar Threads
setBoolean - not working properly
Adding a bit new info to the jforum_user table when registerting
how set "default" inthe name of column ?
Restore problem
prepareStatement returns 0?