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!
These might just be transcription errors or typos, but you should remove the word
table
from yourINSERT
statements, and you don't need single-quotes around column names, so the statement should look like: