UPDATE products SET price = 12 WHERe name = 'coke' AND price = 8;
这些可能只是转录错误或错别字,但您应该
table从
INSERT语句中删除单词,并且在列名周围不需要单引号,因此该语句应类似于:
insert into products (name, price) values ('sprite', 9)
UPDATE products SET price = 12 WHERe name = 'coke' AND price = 8;
这些可能只是转录错误或错别字,但您应该
table从
INSERT语句中删除单词,并且在列名周围不需要单引号,因此该语句应类似于:
insert into products (name, price) values ('sprite', 9)