mysql数据库之dml语句盘点

– DML 数据操纵语言，操作表数据CRUD

– 插入数据 所有非空且没有默认值的必填
– 最缺省
insert into qinhan_user(username,password)
values(‘zhw’,‘2321’);
– 最全
insert into qinhan_user(user_id,username,password,birthday,gender,raw_add_time)
values (5,‘prince’,‘123’,now(),‘M’,now());
select * from qinhan_user;

– 更新数据 where 子句 条件必须！！！！
update qinhan_user
set username=‘CoolZHW’ /设置值/
where user_id=1; /限定范围/

update qinhan_user-- 啊哈哈哈哈哈哈
set birthday=now();

– 删除数据 where
delete from qinhan_user
where username=‘prince’;
select * from qinhan_user;

– 选择语句
select * from qinhan_user;

select username
from qinhan_user
where raw_add_time>‘1999-01-02’ and birthday>‘1990-01-01’;

– 通常为了检查一般将条件也一起打印出来
select username,raw_add_time
from qinhan_user
where raw_add_time>‘1999-01-02’ and birthday>‘1990-01-01’;

– ‘-’ 一个字符 ‘%’ 任意字符
– %str%

– order by …
select *
from qinhan_user
order by gender asc,birthday desc;

– in 判断是否在列表内

– distinct 去重

– 统计总数 count(*)等函数，都是只能进行计算一个值，但是不能带出其他的列值。