SQL进行表更新
语法
update 表名称 set 字段=值,字段=值 where 条件
- 修改张6的CId为2
update Teacher set CId = 2 where Name = '张6'
- 修改张9 姓名为张10,年龄修改为28,工资加1000
update Teacher set Name = '张10' ,Age = '28',Salary += 1000 where Name = '张9'
SQL进行表更新
语法
update 表名称 set 字段=值,字段=值 where 条件
update Teacher set CId = 2 where Name = '张6'
update Teacher set Name = '张10' ,Age = '28',Salary += 1000 where Name = '张9'