数据库sql语句curd操作

添加数据
INSERT INTO `user` (`id`, `name`, `dept`, `art`, `email`, `create_time`) VALUES (NULL, '小米', '天山派', '隔山打牛', 'yu@uu.com', '1530673977');
INSERT INTO `user` VALUES (NULL, '小名', '蛋黄派', '隔山打牛', 'yu@163.com', '1530673977');
插入多条记录
INSERT INTO `user` VALUES (NULL, '小名', '蛋黄派', '隔山打牛', 'yu@163.com', '1530673977')，(NULL, '小花', '城南派', '无影山', 'yu@163.com', '1530673977');

更新数据
UPDATE `user` SET `name` = '天天' WHERE `user`.`id` =10;
更新多个值
UPDATE `user` SET `name` = '天天',`email`='89@189.com' WHERE `user`.`id` =10;

查询数据
select * from `user`;
select * from `user` where dept='隔山打牛' order by 'id' limit 3;
select count(*) as num from `user`;
select concat(`id`,'--', `name`) as `id_name` from `user`;

数据删除
DELETE FROM `user` WHERE `user`.`id` = 9；