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)
)
;
create table ENV
(
USER_CODE INT(8) not null,
CODE_ENV VARCHAR(6) not null,
primary key (USER_CODE, CODE_ENV),
constraint FK_USER foreign key (USER_CODE) references USERS(USER_CODE)
)
;
The tables creation are ok, but when I insert values in the table ENV
without any data in USERS it works but normally it wouldn't.
Something bad in may script ?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
