Re: pb with integrity constraint

2002-01-15 Thread Erv Young
Dominique, At 05:45 AM 1/15/2002 -0800, Steve Edberg wrote: >See doc sections: > > http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html >and > http://www.mysql.com/doc/C/R/CREATE_TABLE.html > > From the CREATE TABLE docs: > > "The FOREIGN KEY, CHECK, and REFERENCES cla

Re: pb with integrity constraint

2002-01-15 Thread Steve Edberg
See doc sections: http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html and http://www.mysql.com/doc/C/R/CREATE_TABLE.html From the CREATE TABLE docs: "The FOREIGN KEY, CHECK, and REFERENCES clauses don't actually do anything. The syntax for them is provided only fo

pb with integrity constraint

2002-01-15 Thread TOMASSONI Dominique
Hi the list, I try to create tables with integrity constraint but it seems no running. I've got the next script : create table USERS ( USER_CODE INT(8) not null, USER_NAME VARCHAR(30)not null, primary key (USER_CODE) ) ; cre