Peter Brawley wrote:
Lola,
/>And got this following error message:
>ERROR 1072 (42000): Key column '(not null)' doesn't exist in table
/
Yes, it's telling you what;s wrong: to define a constraint on a key, the
table def must first define the key.
Looking over the script again, RatingID is being defined, first in
FilmsRatings which I ran to create this table and then in Films, the
create table script which didn't work.
How do I make the table def first define the key explicitly? Or am I
missing something obvious?
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
Freedom is not free.
I'm in Bowie, MD, USA, halfway between DC and Annapolis.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
