MySQL单表操作学习DDL_DML_DQL语句

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

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creatDate` datetime DEFAULT NULL,
  `userName` varchar(20) DEFAULT NULL,
  `pwd` varchar(36) DEFAULT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `age` tinyint(3) unsigned DEFAULT NULL,
  `sex` char(2) DEFAULT NULL,
  `introduce` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

2.插入数据--DML语句

insert into student values(0,'2024-02-25 10;10;10','盘古',
'123456','15612345678',255,'神','开天辟地');
insert into student values(0,'2024-02-25 10;10;10','女娲',
'123456','15612345678',200,'女','造人');
insert into student values(0,'2024-02-25 10;10;10','伏羲',
'123456','15612345678',215,'神','八卦');
insert into student values(0,'2024-02-25 10;10;10','神农',
'123456','15612345678',155,'男','尝百草');
insert into student values(0,'2024-02-25 10;10;10','祖',
'123456','15612345678',115,'神','织布');
insert into student values(0,'2024-02-25 10;10;10','蚩尤',
'123456','15612345678',155,'男','巨兽');
 insert into student (userName,age,introduce) values('仓颉',125,'文字');
 
 

3.基础查询--DQL语句

#基础查询
select * from student;
#非空筛选
selece userName as '姓名',age '年龄',sex '性别'，introduce '介绍'
from student where pwd is not null;
#去重查询
selece distinct sex '性别' from student;
#分页查询关键字limit有两个参数，只写一个代表查询条数
select * from student LIMIT 6,3;
select * from student ORDER BY age asc;