update 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值,update语句的写法:
1、UPDATE table_name
2、SET column1=value1,column2=value2,
3、WHERE column ( 1 ) =value ( 1 ),column ( 2 ) =value ( 2 ) ...and column ( n ) =value ( n );
4、UPDATE Person SET Address = 'Zhongshan 23', City = 'Nanjing',WHERE LastName = 'Wilson'
本文链接:https://www.miaozhishe.com/jiaoyu/zlje2z.html