faqts : Computers : Databases : MySQL : Language and Syntax : Queries : Create Table

+ Search
 Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

23 of 40 people (58%) answered Yes
Recently 5 of 10 people (50%) answered Yes

Entry

Is "FOREIGN KEY REFERENCES" implemented in the new versions of MySQL?

Feb 8th, 2000 05:45
Nathan Wallace, Jan Dvorak
 


Yes.  It works in 3.23 for sure.

It doesn't do anything though.

MySQL merely tolerates that syntax in CREATE TABLE.  It doesn't create
the index for you.  It doesn't even reproduce this information in the
output of 'mysqldump' (this may change soon).