摘要：//插入數(shù)據(jù)INSERT INTO `user` (`name`, `sex`, `age`, `email`, `password`, `status`, `create_time`) VALUES ('金庸', '0', '90', 'email@php.cn', sha1(123456), '1', '1

//插入數(shù)據(jù)

INSERT INTO `user` (`name`, `sex`, `age`, `email`, `password`, `status`, `create_time`) VALUES ('金庸', '0', '90', 'email@php.cn', sha1(123456), '1', '1548656957');

//簡化插入數(shù)據(jù)

INSERT `user` VALUES (null,'林清玄', '1', '90', 'email@php.cn', sha1(123456), '1', now()),(null,'唐伯虎', '1', '90', 'email@php.cn', sha1(123456), '1', now())

//更新語句

UPDATE `user` SET `age` = 78,`email` = 'php@php.cn' WHERE `id` = 20

//查詢

SELECT * FROM `user`;

SELECT `name`,`age` FROM `user`;

SELECT `name`,`age` FROM `user` WHERE status = 1 ORDER BY `age` LIMIT 2;

//SELECT計算

SELECT 20*30 AS result;

//字符串拼接

SELECT concat('*',`id`,`name`) AS `user_info` FROM `user` WHERE `status` =1;

SELECT concat_ws('*',`id`,`name`) AS `user_info` FROM `user` WHERE `status` =1;

SELECT COUNT(*) AS res FROM `user` WHERE status =1

//刪除

DELETE FROM `user` WHERE `id`=16

//主鍵排序

truncate table `user`

//主鍵排序

ALTER TABLE `user` DROP `id`;

ALTER TABLE `user` ADD `id` int(6) PRIMARY KEY NOT NULL AUTO_INCREMENT FIRST;

批改老師：查無此人批改時間：2019-01-28 15:34:41
老師總結(jié)：作業(yè)完成的不錯。我好像沒教mysql函數(shù)，自學(xué)的？不錯，繼續(xù)加油。