Re: Can't Create Foreign Key Constraints

Hello. You can post a bug: http://dev.mysql.com/doc/refman/5.0/en/bug-reports.html Lola J. Lee Beno wrote: > Gleb Paharenko wrote: > >> Hello. >> >> The query which is works is: > > > > Thanks - just what I needed. Looks like I'll need to be extra careful > with sql scripts generated from

Re: Can't Create Foreign Key Constraints

Gleb Paharenko wrote: Hello. The query which is works is: Thanks - just what I needed. Looks like I'll need to be extra careful with sql scripts generated from Mysql Workbench, which is still alpha right now. -- Lola - mailto:[EMAIL PROTECTED] http://www.lolajl.net | Blog at http://www

Re: Can't Create Foreign Key Constraints

Hello. The query which is works is: CREATE TABLE `Films` ( `FilmID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `MovieTitle` TEXT NULL ,`PitchText` TEXT NULL, `AmountBudgeted` DECIMAL(11, 0) NULL, `RatingID` INT(11) unsigned , `Summary` L

Re: Can't Create Foreign Key Constraints

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 b

Re: Can't Create Foreign Key Constraints

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. PB - Lola J. Lee Beno wrote: I'm trying to create foreign

Re: Can't Create Foreign Key Constraints

Michael Stassen wrote: 1) I'm not sure what you are intending with "(`(not null)`)" in the middle of your foreign key definition, but that isn't valid mysql syntax. See the manual for the correct syntax . This is f

Re: Can't Create Foreign Key Constraints

Lola J. Lee Beno wrote: I'm trying to create foreign key constraints and keep getting an error message 1005 (I did look it up, but didn't see an obvious solution to fixing this for my database). The version I'm using is 5.0.17-max. I used Mysql WorkBench to create the database schema and had