摘要：添加数据INSERT INTO `user` (`id`, `name`, `dept`, `art`, `email`, `create_time`) VALUES (NULL, '小米', '天山派', '隔山打牛', 'yu@uu.com', '1530673977');INSERT INTO `user` VA
添加数据
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；
批改老师：韦小宝批改时间：2019-01-15 13:14:12
老师总结：写的很不错 sql语句的灵活性很高 没事一定要多研究研究 sql掌握的熟练操作任何数据库都是不在话下的
