This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Are you sure that KEY on its own, rather than FOREIGN KEY and PRIMARY KEY, is correct MySQL syntax?
Joined: Jan 01, 2010
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.