mysql的增删改查

abstract：-- 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

Correcting teacher：查无此人Correction time：2019-04-30 09:10:42
Teacher's summary：完成的不错。mysql最基础的语句就是增删查改。继续加油。