摘要：-- Adminer 4.7.1 MySQL dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode =
-- Adminer 4.7.1 MySQL dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `uid` int(20) unsigned NOT NULL AUTO_INCREMENT, `uname` varchar(20) NOT NULL, `age` int(3) unsigned zerofill NOT NULL, PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; INSERT INTO `users` (`uid`, `uname`, `age`) VALUES (1, '张三', 039), (3, '谢逊', 080), (4, '赵敏', 025); -- 2019-04-29 07:05:38
增
INSERT INTO users (`uname`,`age`) values ('赵敏',23);
删
delete from users where uid=2 and uname='张无忌';
改
UPDATE `users` SET `age`=25 where uid=4;
查
SELECT * FROM `users` where `uid`= 1
批改老师：查无此人批改时间：2019-04-30 09:10:42
老师总结：完成的不错。mysql最基础的语句就是增删查改。继续加油。
