SQL update 语句
SQL UPDATE 语句
UPDATE 语句用于更新表中已存在的记录。
SQL UPDATE 语法
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
实例
实例表
+----+--------------+---------------------------+-------+---------+
| id | name | url | alexa | country |
+----+--------------+---------------------------+-------+---------+
| 1 | Google | https://www.google.cm/ | 1 | USA |
| 2 | 淘宝 | https://www.taobao.com/ | 13 | CN |
| 3 | Facebook | https://www.facebook.com/ | 3 | USA |
| 4 | 百度 | https://www.baidu.com/ | 4 | CN |
+----+--------------+---------------------------+-------+---------+
修改 百度的 alexa排名
UPDATE Websites SET alexa='5000', country='CN' WHERE name='百度';
结果:
| 4 | 百度 | https://www.baidu.com/ | 5000 | CN |