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