Re: question: check constraint

2004-03-13 Thread Paul DuBois
At 20:10 -0800 3/13/04, Andrew Zhu wrote: 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 ad

question: check constraint

2004-03-13 Thread Andrew Zhu
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