????：添加數(shù)據(jù)INSERT INTO `user` (`id`, `name`, `dept`, `art`, `email`, `create_time`) VALUES (NULL, '小米', '天山派', '隔山打牛', 'yu@uu.com', '1530673977');INSERT INTO `user` VA

添加數(shù)據(jù)
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, '小花', '城南派', '無(wú)影山', 'yu@163.com', '1530673977');

更新數(shù)據(jù)
UPDATE `user` SET `name` = '天天' WHERE `user`.`id` =10;
更新多個(gè)值
UPDATE `user` SET `name` = '天天',`email`='89@189.com' WHERE `user`.`id` =10;

查詢數(shù)據(jù)
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`;

數(shù)據(jù)刪除
DELETE FROM `user` WHERE `user`.`id` = 9；

?? ???：韋小寶?? ??：2019-01-15 13:14:12
???? ??：寫的很不錯(cuò) sql語(yǔ)句的靈活性很高 沒事一定要多研究研究 sql掌握的熟練操作任何數(shù)據(jù)庫(kù)都是不在話下的