How, in a sql script, do I gracefully fail an insert? For example, I insert a record that has an primary key of 1, and it already exists. I want my script to Move down to the next record, not fail out. Thanks!
If you're executing the script with the mysql client, invoke it with the --force option.
Not sure if that's "graceful", though. :-)
dan
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]