Hi

I'm trying to brush up on my mysql, The following is code I'm trying to follow, taken out of a book, but it fails when trying to create the 2nd table, I've gone through it but can't see whats wrong.  BTW I'm using mysql v 5.0.22 if this makes a difference.

I've cut out most of it but left the 1st table to fail (artists_events).

Code:

# phpMyAdmin MySQL-Dump # version 2.2.6 # http://phpwizard.net/phpMyAdmin/ # http://www.phpmyadmin.net/ (download page) # # Host: localhost # Generation Time: Aug 28, 2002 at 11:19 AM # Server version: 3.23.51 # PHP Version: 4.0.4 # Database : `tunein` # -------------------------------------------------------- # # Table structure for table `artists` # DROP TABLE IF EXISTS `artists`; CREATE TABLE `artists` (  `artist_id` int(4) NOT NULL auto_increment,  `artist_name` varchar(100) NOT NULL default '',  PRIMARY KEY  (`artist_id`),  UNIQUE KEY `artist_name` (`artist_name`) ) TYPE=InnoDB COMMENT='Musical performer or group.'; # -------------------------------------------------------- # # Table structure for table `artists_events` # DROP TABLE IF EXISTS `artists_events`; CREATE TABLE `artists_events` (  `artist_event_id` int(4) NOT NULL auto_increment,  `artist_id` int(4) NOT NULL default '0',  `event_id` int(4) NOT NULL default '0',  PRIMARY KEY  (`artist_event_id`),  KEY `artist_id` (`artist_id`),  KEY `event_id` (`event_id`),  FOREIGN KEY (`artist_id`) REFERENCES `tunein.artists` (`artist_id`),  FOREIGN KEY (`event_id`) REFERENCES `tunein.events` (`event_id`) ) TYPE=InnoDB COMMENT='Lookup table for artists and events where they perform.'; # --------------------------------------------------------

Ok, kinda sorted the problem out, even got the data in to the tables

Question though, When using Foreign Keys and References, why does the data need to be put into the tables in a particular order?

Hope the question makes sense, not too sure if I'm asking the right one  

Not sure either, Chris ... my mind's not in SQL mode at the moment - sorry.  Come back and nag me in a couple of days if you need a further bit of help to move practically forward or an answer on the side issue raised.

Weren't you supposed to be coming to see us some time?   Next couple of weejends are frannkly busied out but it then starts getting much more do-able from Mid September!

Thanks Graham, Yes believe me we still want to come down and catch up, perhaps a curry as well

Will bounce some dates off the boss wife and see when we can make it.

Look forward to seeing you soon.

Cheers

Chris

---