At 10:07 AM +0200 7/26/99, Christian BRUNO wrote:
>on the CREATE TABLE syntax, in the MySQL manual, i noticed
>a clause "ON DELETE" and "ON UPDATE" with options 'restrict',
>is this syntax only allowed for compatibility ?
That's what the manual says, yes:
>The FOREIGN KEY, CHECK and REFERENCES clauses don't actually do
>anything. The syntax for them is provided only for compatibility, to
>make it easier to port code from other SQL servers and to run
>applications that create tables with references. See section 5.3
>Functionality missing from MySQL.
Paul DuBois, paul@stripped