SQL UPDATE语句
时间: 2023-10-30 14:08:40 浏览: 55
SQL UPDATE语句用于更新表中已存在的记录。其基本语法如下所示:
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
其中,table_name是要更新的表名,column1、column2等是要更新的列名,value1、value2等是要更新的值,condition是更新的条件。通过指定条件,可以选择性地更新表中的记录。\[1\]\[2\]
另外,UPDATE语句还可以使用NULL进行更新,即将某列的值清空。例如,可以使用以下语句将满足条件的学生的数学成绩设置为NULL:
UPDATE student SET shuxue = NULL WHERE yingyu > 80;
这条语句的含义是,在表student中,将满足英语成绩大于80的学生的数学成绩列(shuxue)更改为NULL。\[3\]
#### 引用[.reference_title]
- *1* [SQL UPDATE 语句](https://blog.csdn.net/samLi0620/article/details/128524719)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* [SQL UPDATE 语句(更新表中的记录)](https://blog.csdn.net/BUITEKI/article/details/116426933)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [SQL基础_数据更新(UPDATE使用)](https://blog.csdn.net/weixin_45280346/article/details/95859534)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^control,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]