Re: insert after delete is not atomic

[Brent Baisley]

This doesn't directly address the problem you are having, but it probably is a better way of doing it. Have you looked into using the REPLACE function instead of a delete and insert. It should be faster and more reliable.

I assume since you are using the ignore statement in your insert that you were getting an error or warning on insert because of a duplicate key. I don't see how using ignore helps, except that you suppress a warning.

sql, query

On Tuesday, February 4, 2003, at 11:02 PM, Mudit Wahal wrote:

I have a delete statement and an insert statment. I'm replacing a line but I want
to make sure, that its deleted.

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


---------------------------------------------------------------------
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