Being fairly new to mysql, I'm trying to do the following and coming up empty handed.
I'm in the process of writing a set of sql scripts (aka, text files to be sourced (\.) inside of the MySQL interpreter) Ideally, I would like to be able to have the following behaviour: On error, rollback the current transaction and stop execution. If, in addition, the source can exit with an error code to facilitate nested behavior, all the better. Why is this all being done via sql scripts and not perl/python/etc? Because there is no need for a lot of control; in essence it is a bunch of create and populate table tasks. Being able to stop cold on an error in these situations would be a great thing. Any help on how to do "on error..." would be greatly appreciated. - clark. --------------------------------------------------------------------- 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
