sqlitestudio - SQLite3 error: row value missused -
i'm trying use 2 update queries on database:
update equipment set equip_level = 'hero' equip = ('amulet of immortality'); update equipment set equip_level = 'master' equip = ('shield of pitch black', 'blade of magebane', 'leggings of spikes', 'gloves of quickling skin', 'helm of fire king', 'scythe of death'); the first 1 works fine second 1 (with multiple entries) gives me following error:
[11:37:16] error while executing sql query on database 'test': row value misused the tutorial i'm looking @ (https://digitalfellows.commons.gc.cuny.edu/2016/04/08/fun-times-with-sqlite-or-a-beginners-tutorial-to-data-management-and-databases-with-sql/) uses following format second query:
update equipment set equip_level = 'master' equip = in ('shield of pitch black', 'blade of magebane', 'leggings of spikes', 'gloves of quickling skin', 'helm of fire king', 'scythe of death') but gives me syntax error:
[11:49:48] error while executing sql query on database 'test': near "in": syntax error how can correct this?
remove equals sign:
update equipment set equip_level = 'master' equip in ('shield of pitch black', 'blade of magebane', 'leggings of spikes', 'gloves of quickling skin', 'helm of fire king', 'scythe of death')
Comments
Post a Comment