lundi 16 mars 2015

Update Query with limit cause SQLite

i have table in SQLite named TBL_data


i have two fields id and name


All id is set to the -1


i want to update first occurrence of record


for this i have used


update TBL_data set name = 'XYZ' where id = -1 limit 1


it shows error, is there any other way ?


Aucun commentaire:

Enregistrer un commentaire