MySQL学习必备SQL_DDL_DML_DQL

MySQL创建数据库需要自行创建

1，学生表DDL

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学号',
  `createDate` datetime DEFAULT NULL,
  `userName` varchar(20) DEFAULT NULL,
  `pwd` varchar(36) DEFAULT NULL,
  `phone` varchar(11) DEFAULT NULL,
  `age` tinyint(3) DEFAULT NULL,
  `sex` char(2) DEFAULT '男',
  `introduce` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

2，插入学生信息DML

insert into student values (0,'2024-02-25 10:10:10','小新','123',
'12345678',3,'男','蜡笔小新');
insert into student values (0,'2024-02-25 10:10:10','小蓝','123',
'12345678',23,'女','魔仙小蓝');
insert into student values (0,'2024-02-25 10:10:10','美琪','123',
'12345678',13,'女','小魔仙');
insert into student values (0,'2024-02-25 10:10:10','美雪','123',
'12345678',13,'女','小魔仙');
insert into student values (0,'2024-02-25 10:10:10','严莉莉','123',
'12345678',13,'女','小黑魔仙');
insert into student values (0,'2024-02-25 10:10:10','图图','123',
'12345678',3,'男','动耳神功');
insert into student values (0,'2024-02-25 10:10:10','小猪猪','123',
'12345678',5,'男','猪猪侠');

3，基础查询测试DQL