At 13:44 -0500 10/13/03, dan orlic wrote:
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]



Reply via email to