SQL Server UPDATE 语句：更新数据指南

SQL Server \u7684 UPDATE \u8bed\u53e5\u7528\u4e8e\u66f4\u65b0\u8868\u4e2d\u7684\u6570\u636e\u3002\u5176\u57fa\u672c\u8bed\u6cd5\u5982\u4e0b\uff1a\n\n\nUPDATE table_name\nSET column1 = value1, column2 = value2, ...\nWHERE condition;\n\n\n- table_name\uff1a\u8981\u66f4\u65b0\u6570\u636e\u7684\u8868\u540d\u3002\n- column1, column2, ...\uff1a\u8981\u66f4\u65b0\u7684\u5217\u540d\u3002\n- value1, value2, ...\uff1a\u8981\u66f4\u65b0\u7684\u503c\u3002\n- WHERE condition\uff1a\u53ef\u9009\u9879\uff0c\u7528\u4e8e\u6307\u5b9a\u66f4\u65b0\u7684\u6761\u4ef6\u3002\n\n\u4f8b\u5982\uff0c\u501f\u8d70\u6709\u4e00\u4e2a\u540d\u4e3a "customers"\u7684\u8868\uff0c\u5176\u4e2d\u6709 "customer_id", "customer_name" \u548c "city" \u4e09\u4e2a\u5217\u3002\u8981\u5c06 customer_id \u4e3a 1 \u7684\u8bb0\u5f55\u7684 customer_name \u66f4\u65b0\u4e3a "John"\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b UPDATE \u8bed\u53e5\uff1a\n\n\nUPDATE customers\nSET customer_name = 'John'\nWHERE customer_id = 1;\n\n\n\u8fd9\u6837\u5c31\u4f1a\u5c06 customer_id \u4e3a 1 \u7684\u8bb0\u5f55\u7684 customer_name \u66f4\u65b0\u4e3a "John"\u3002\n\n\u5982\u679c\u8981\u540c\u65f6\u66f4\u65b0\u591a\u4e2a\u5217\u7684\u503c\uff0c\u53ef\u4ee5\u5728 SET \u5b50\u53e5\u4e2d\u4f7f\u7528\u952e\u5206\u9694\u7684\u591a\u4e2a\u5217\u540d\u548c\u503c\u5bf9\u3002\u4f8b\u5982\uff0c\u8981\u5c06 customer_id \u4e3a 1 \u7684\u8bb0\u5f55\u7684 customer_name \u66f4\u65b0\u4e3a "John"\uff0c city \u66f4\u65b0\u4e3a "New York"\uff0c\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b UPDATE \u8bed\u53e5\uff1a\n\n\nUPDATE customers\nSET customer_name = 'John', city = 'New York'\nWHERE customer_id = 1;\n\n\n\u8fd9\u6837\u5c31\u4f1a\u5c06 customer_id \u4e3a 1 \u7684\u8bb0\u5f55\u7684 customer_name \u66f4\u65b0\u4e3a "John"\uff0c city \u66f4\u65b0\u4e3a "New York"\u3002\n\n\u6ce8\u610f\uff1a\u5728\u4f7f\u7528 UPDATE \u8bed\u53e5\u66f4\u65b0\u6570\u636e\u65f6\uff0c\u5fc5\u987b\u8c28\u614e\u4f7f\u7528 WHERE \u6761\u4ef6\uff0c\u4ee5\u4fdd\u8bc1\u53ea\u66f4\u65b0\u7b26\u5408\u6761\u4ef6\u7684\u8bb0\u5f55\uff0c\u907f\u514d\u8bef\u64cd\u4f5c\u5bfc\u81f4\u6570\u636e\u7684\u610f\u5916\u4fee\u6539\u3002