Changing a value in SQLite3

2019-03-18 00:19发布

I'll start off by showing the code:

create table products ('name' text primary key, 'price' INTEGER)
insert into table products ('name', 'price') values ('coke', 8)
insert into table products ('name', 'price') values ('sprite', 9)

What would be the SQLite3 code to change the value of the price column for the coke row to 12.
So I want the output to be coke 12 sprite 9.

Thanks alot guys!

1条回答
男人必须洒脱
2楼-- · 2019-03-18 01:03
UPDATE products 
   SET price = 12 
 WHERE name = 'coke' AND price = 8;

These might just be transcription errors or typos, but you should remove the word table from your INSERT statements, and you don't need single-quotes around column names, so the statement should look like:

insert into products (name, price) values ('sprite', 9)
查看更多
登录 后发表回答