mysql笔记4之数据操作
1修改数据
插入：insert into stu(id,name,age,addr) values(2,"李四",44,"重庆");
2修改某一列
updata stu set age = 23 where name = "李四"
3修改多个列
updata stu set age = 40,addr="湖北" where name = "李四"
1修改数据
插入：insert into stu(id,name,age,addr) values(2,"李四",44,"重庆");
2修改某一列
updata stu set age = 23 where name = "李四"
3修改多个列
updata stu set age = 40,addr="湖北" where name = "李四"