Alle 14:04, giovedì 9 novembre 2006, Heikki Tuuri ha scritto:
Giorgio,
InnoDB only implements MATCH SIMPLE. MySQL/InnoDB ignores the MATCH
clause that you specify in the foreign key constraint definition.
Thanks a lot :-)
Giorgio
--
MySQL General Mailing List
For list archives:
Giorgio,
InnoDB only implements MATCH SIMPLE. MySQL/InnoDB ignores the MATCH
clause that you specify in the foreign key constraint definition.
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
A referential constraint is satisfied if one of the following con-
Hi,
I was looking at the CREATE TABLE syntax and I saw this reference definition
for InnoDB tables:
reference_definition:
REFERENCES tbl_name [(index_col_name,...)]
[MATCH FULL | MATCH PARTIAL | MATCH SIMPLE]
[ON DELETE reference_option]
[ON UPDATE reference_option]
reference_option:
RESTRICT
Hi,
I was looking at the CREATE TABLE syntax and I saw this reference definition
for InnoDB tables:
reference_definition:
REFERENCES tbl_name [(index_col_name,...)]
[MATCH FULL | MATCH PARTIAL | MATCH SIMPLE]
[ON DELETE reference_option]
[ON UPDATE reference_option]
reference_option:
RESTRICT