Re: [GENERAL] SQL sentence to insert where updated rows is zero...

2013-01-31 Thread Vincent Veyron
Le jeudi 31 janvier 2013 à 17:25 +0100, Glus Xof a écrit : > It's just to ask you if there is a single SQL sentence to INSERT > values in case of UPDATE WHERE returns 0 rows updated. I mean, If I > write something like, > > # update my_table set column1='value' where column2='key_value'; > > And

[GENERAL] SQL sentence to insert where updated rows is zero...

2013-01-31 Thread Glus Xof
Hi guys, It's just to ask you if there is a single SQL sentence to INSERT values in case of UPDATE WHERE returns 0 rows updated. I mean, If I write something like, # update my_table set column1='value' where column2='key_value'; And system replies me with one "UPDATE 0" because there is no row a