Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.telusplanet.net!newsfeed.telus.net!snoopy.risq.qc.ca!newsfeed.news2me.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.server Subject: Re: MySQL 4 Date: Fri, 08 Aug 2003 08:30:09 -0700 Organization: EXE Message-ID: <3F33C201.9D409708@exxesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: <3f3239c9$3$10356$afc38c87@news.optusnet.com.au> <3F32AE33.2AA0420@exxesolutions.com> <3F32D112.53504C72@exxesolutions.com> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 40 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:240105 Heikki Tuuri wrote: > Daniel, > > "Daniel Morgan" kirjoitti viestissä > news:3F32D112.53504C72@exxesolutions.com... > ... > > > And will that enforce a constraint such as 'a date of birth can not be in > the > > future' ? > > sorry, CHECK constraints are not implemented yet in MySQL. > > Stored procedures already work in MySQL-5.0. Maybe soon we can write CHECK > constraints using triggers. > > > -- > > Daniel Morgan > > Best regards, > > Heikki Tuuri > Innobase Oy > http://www.innodb.com > Transactions, foreign keys, and a hot backup tool for MySQL The question I asked has nothing to do with check constraints. SYSDATE can not be used in a check constraint. It has to do with triggers. But the point of the question is irrelevant to how it is done. If this type of constraint is not possible ... neither is enforcing data integrity. -- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)