Bo, ----- Alkuperäinen viesti ----- Lähettäjä: "Bo Lorentsen" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Friday, September 26, 2003 9:41 AM Aihe: Re: REFERENCES question in mySQL 4.1 - Take 2
> On Fri, 2003-09-26 at 01:14, Heikki Tuuri wrote: > > > > CREATE TABLE phone (id char(5) not null > > > REFERENCES person(id), > > > num char(10) not null, PRIMARY KEY (id, num)); > > > > It simply ignores that REFERENCES definition. It is in the TODO list to add > > support for that syntax, too. Until then you have to use the 'long' syntax: > Is it possible to make it generate an error when the wrong syntax > occure, as ignoring the FK syntax is not very assuring ? yes, this is a known problem. > /BL Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for MySQL Order MySQL support from http://www.mysql.com/support/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]