spot the problem.....
Posted by Chris_Isaac (Chris Isaac), 28 August 2007Hi
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).
Posted by Chris_Isaac (Chris Isaac), 29 August 2007Ok, 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
Posted by admin (Graham Ellis), 30 August 2007Not 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!
Posted by Chris_Isaac (Chris Isaac), 30 August 2007Thanks Graham, Yes believe me we still want to come down and catch up, perhaps a curry as well
Will bounce some dates off the
Look forward to seeing you soon.
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: firstname.lastname@example.org • WEB: http://www.wellho.net • SKYPE: wellho