sql增删改查语句

摘要：增：INSERT INTO `zh_user`  (`is_admin`, `name`, `email`, `mobile`, `password`, `status`, `create_time`, `update_time`) VALUES ('0','test','test@php.cn','15527798632'

增：

INSERT INTO `zh_user`  (`is_admin`, `name`, `email`, `mobile`, `password`, `status`, `create_time`, `update_time`)

VALUES ('0','test','test@php.cn','15527798632',sha1('abcccc'),'1','1545798621','1545798621');

删

delete from `zh_user` where `id`= 7;

改

update `zh_user` set `mobile`=112 where `name`='qqq';

查

select `id`,`name` from `user` where `status`=1 order by `id`  desc limit 3;

批改老师：韦小宝批改时间：2018-12-26 14:57:48
老师总结：光总结还是不行的，课后一定要多实际的去练习练习