I think, the two formats you raised are both that of
foreign key constraint:
when there is a composite foreign key (more than 1
attribute in a table involved), you must use "foreign
key" clause.
if there is only a simple foreign key, you can use
either format.
--- Egor Egorov <[EMAIL PROTECTED]
Mysql 4.0.12 on win xp.
Question: is the check constraint supported?
Example:
create table temp (
c1 varchar (50) check (c1 like "[EMAIL PROTECTED]")
);
insert into temp values ("whatever");
will succeed. Is my constraint wrong (say to check the
email address)? or this is just parsed without
en
