摘要:Create例如:CREATE TABLE `test` ( `id` INT NOT NULL AUTO_INCREMENT , `user` INT NOTNULL , `status` INT NOT NULL , 
Create
例如:CREATE TABLE `test` ( `id` INT NOT NULL AUTO_INCREMENT , `user` INT NOTNULL , `status` INT NOT NULL , `create_time` INT NOT NULL , PRIMARY KEY (`id`))ENGINE = InnoDB;
Update
例如:INSERT INTO `test` (`id`, `user`, `status`, `create_time`) VALUES (NULL, '101', '1', '123');
UPDATE `test` SET `user` = '112233' WHERE `test`.`id` = 1;
Read:
例如:SELECT COUNT(*) AS Number FROM `test`;
Delete:
例如:DELETE FROM `test` WHERE `test`.`id` = 1;
批改老师:天蓬老师批改时间:2018-12-25 13:08:52
老师总结:写得真简单, 不知是否记住了, 还得多多练习