abstract：添加數據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；

Correcting teacher：韋小寶Correction time：2019-01-15 13:14:12
Teacher's summary：寫的很不錯 sql語句的靈活性很高 沒事一定要多研究研究 sql掌握的熟練操作任何數據庫都是不在話下的