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]

Reply via email to