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 = "李四"