AIL PROTECTED]
Cc: Mattias J; mysql@lists.mysql.com
Subject: Re: Insert if Update failed without Select
[EMAIL PROTECTED] wrote:
>>Please also note hat UPDATE returns the number of records updated. If
your
>>UPDATE returns 0, you know that the record does not exist,
[EMAIL PROTECTED] wrote:
Please also note hat UPDATE returns the number of records updated. If your
UPDATE returns 0, you know that the record does not exist, and you might
want to INSERT instead.
There is one situation where the number of records updated will return
0, yet the row exists.
>Please also note hat UPDATE returns the number of records updated. If your
>UPDATE returns 0, you know that the record does not exist, and you might
>want to INSERT instead.
There is one situation where the number of records updated will return
0, yet the row exists. If you update the record w
Please also note hat UPDATE returns the number of records updated. If your
UPDATE returns 0, you know that the record does not exist, and you might
want to INSERT instead.
At 2005-01-15 14:54, you wrote:
At 2005-01-15 14:48, you wrote:
Without using Select statement, how can I execute Insert SQL
At 2005-01-15 14:48, you wrote:
Without using Select statement, how can I execute Insert SQL statement if
Update action is failed?
I may be asking for too much. If Select statemnet have to be used to
determine the existence of a recordset, what is an efficient way to
execute Insert if Update is
Hi,
Without using Select statement, how can I execute Insert SQL statement
if Update action is failed?
I may be asking for too much. If Select statemnet have to be used to
determine the existence of a recordset, what is an efficient way to
execute Insert if Update is failed? I m using MySQL 5.0