创建数据表--DDL语句
CREATE TABLE `schooldb` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学号',
`createdate` datetime DEFAULT NULL COMMENT '创建时间',
`username` varchar(20) DEFAULT NULL COMMENT '姓名',
`pwd` varchar(30) DEFAULT NULL COMMENT '密码',
`phone` varchar(11) DEFAULT NULL COMMENT '手机号',
`age` int(3) DEFAULT NULL COMMENT '年龄',
`sex` varchar(2) DEFAULT NULL COMMENT '性别',
`introduce` varchar(255) DEFAULT NULL COMMENT '简介',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
创建数据库--DML
INSERT INTO schooldb VALUES (0,'2022-02-02 10:00:00','葫芦爷爷','123456','12345678911',69,'男','葫芦娃的爷爷。');
INSERT INTO schooldb VALUES (0,'2022-02-02 10:00:00','蛇精','123457','12345678912',28,'女','抓走了葫芦娃的爷爷。');
INSERT INTO schooldb VALUES (0,'2022-02-02 10:00:00','大娃','123458','12345678913',14,'男','力大无穷,开山劈地。');
INSERT INTO schooldb VALUES (0,'2022-02-02 10:00:00','二娃','123459','12345678914',14,'男','千里眼,顺风耳。');
SELECT *FROM schooldb
创建数据库--DQL语句
SELECT username as '用户名',age 年龄,sex 性别,introduce 简介 FROM schooldb WHERE pwd is not null;
SELECT DISTINCT sex '性别类型' FROM schooldb;
SELECT * FROM schooldb ORDER BY username desc;
SELECT* FROM schooldb limit 4,1;
#分页查询-limit是一个重载的函数,当只有一个参数的时候代表行数,两个参数limit分页:参数1、从n行开始查询=(当前页-1)*每页条数