MySQL(1)：新建表，增，删，改，查

Mysql创建表和插入数据

一、创建数据库表：

CREATE TABLE `USERS` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `NAME` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `EMAIL` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `AGE` int(11) DEFAULT NULL,
  `SEX` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `ID_CARD` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `MOBILE_PHONE` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `VISA_CARD` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `OFFICER_CARD` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `ADDRESS` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`ID`) USING BTREE
)

二、插入数据:

INSERT INTO `USERS` VALUES ('1', '陈欢', 'www5@163.com', '1', 'M', '460025198109101501', '13581696800', 'SYP618183458', '军字第00111209号', '北京市朝阳区立水桥北');
INSERT INTO `USERS` VALUES ('2', '李小冉', 'www4@163.com', '11', 'M', '460025198109101502', '13581696801', 'SYP618183458', '军字第00111210号', '北京市朝阳区立水桥北test');
INSERT INTO `USERS` VALUES ('3', '胡绍', 'www3@163.com', '28', 'M', '460025198109101503', '13581696802', 'SYP618183458', '军字第00111211号', '北京市朝阳区大屯北');
INSERT INTO `USERS` VALUES ('4', '张军', 'www2@163.com', '45', 'M', '460025198109101504', '13581696803', 'SYP618183458', '军字第00111212号', '北京市朝阳区国贸');
INSERT INTO `USERS` VALUES ('5', '王谢', 'www1@163.com', '30', 'M', '460025198109101505', '13581696804', 'HTG709131954', '军字第00111213号', '北京市东城培新街');
INSERT INTO `USERS` VALUES ('123456780', '郑网', 'wwwtest@163.com', '24', 'M', '460025198109101500', '13581696805', 'INR665993748', '军字第00111208号', '北京市朝阳区立水桥南');

三、修改数据：
例如:

UPDATE USERS SET `NAME`="胡小网" where ID=1

四、删除数据：

使用delete from 表名 where 字段=值,删除多条记录

例如：DELETE FROM USERS WHERE `NAME`="郑网"

使用delete from 表名 where 字段 in(值1, 值2, 值...),删除多条记录

五、查询数据

select * from USERS;

select name from USERS where id=1;

select * from users where name="小王" and AGE=35；

参考：MySQL DELETE 语句 | 菜鸟教程