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

Popular posts from this blog

javascript - Create a stacked percentage column -

Optimising Firebase database by automatically overwriting data -

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -