Chugh, Tuesday, August 13, 2002, 2:40:54 PM, you wrote: CS> We are in the process of transferring our databse from Oracle to MYSQL. CS> Oracle has some triggers to insert into the table on some events. How can we CS> handle this dynamic insertion of triggers in MYSQL. CS> Also what is the alternative for check constraint of Oracle in MYSQL
Unfortunatly MySQL doesn't support triggers yet. CHECK constraint also doesn't do anything. You should do it on the client level. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
