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
enforcement?

Thanks

__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to