mysql> create table test1 (
-> a varchar(10) not null,
-> b varchar(10),
-> constraint pk_test1 primary key(a));
Query OK, 0 rows affected (0.02 sec)
mysql> create table test2 (
-> c varchar(10) references test1(a),
-> d varchar(10));
Query OK, 0 rows affected (0.02 sec)
mysql> insert into test2 values('1','1');
Query OK, 1 row affected (0.04 sec)
mysql> drop table test1;
Query OK, 0 rows affected (0.00 sec)
I'm not understand, why there is no error with
my script. I'm using mysql 3.23.43.
Best regards,
yusuf
---------------------------------------------------------------------
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
