课程3 DML(数据操作语言)

一.插入数据

insert into表名(列名1,列名2,… )values(列值1,列值2,…)

mysql> insert into stu
    -> (id,name,age,sex)
    -> values(1,'melia',21,'f');

不给入插入列那么默认插入所有类
值的顺序按照创建表的列顺序相同

二.修改数据

更新数据

mysql> update stu set age=20
    -> where name='melia' or id=1;
    
mysql> update stu set age=age+1
    -> where age>=20 and age<= 23;
    
mysql> update stu set age=age+1
    -> where age between 20 and 30;
    
mysql> update stu set age=age+1
    -> where name in <'melia','pendy'>;

三.删除数据

mysql> delete from stu where id =3;