MySQL单表学习DDL-DML-DQL语句

1创建数据表---DDL语句

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学号',
  `creatDate` datetime DEFAULT NULL COMMENT '创建时间',
  `userName` varchar(20) DEFAULT NULL COMMENT '用户名',
  `pwd` varchar(36) DEFAULT NULL COMMENT '密码',
  `phone` varchar(11) DEFAULT NULL COMMENT '手机号',
  `age` tinyint(3) unsigned DEFAULT NULL COMMENT '年龄',
  `sex` char(2) DEFAULT NULL COMMENT '姓名',
  `intrduce` varchar(255) DEFAULT NULL COMMENT '简介',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2、插入数据------DML语句

insert into student values(0,'2024-02-25 10:10:10','盘古','123456','15612345678',255,'神','123');
insert into student values(0,'2024-02-25 10:10:10','女娲','123456','15612345678',200,'女','123');
insert into student values(0,'2024-02-25 10:10:10','伏羲','123456','15612345678',255,'神','123');
insert into student values(0,'2024-02-25 10:10:10','神农','123456','15612345678',255,'男','123');
insert into student values(0,'2024-02-25 10:10:10','嫘祖','123456','15612345678',255,'神','123');
insert into student values(0,'2024-02-25 10:10:10','蚩尤','123456','15612345678',255,'男','123');
insert into student(userName,age,intrduce)values('仓颉',123,'123');
select*from student;

3、

4

select*from student;
select userName as'姓名'age 年龄，sex'性别'
from student where pwd is not nul;
select distinct sex'性别' from student;
select*from student LIMIT 6,3;
select*from student ORDER BY age asc;