数据库名可以为【schoolDB】、【uft8】、【uft8_general_ci】
建表语句
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 NULL,
`introduce` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
插入数据
insert into student values(0,'2024-2-25 10:00:00','王源','123',
'13453453453',24,'男','客厅狂欢。');
insert into student values(0,'2024-2-25 10:00:00','王俊凯','123',
'13453453453',25,'男','重生之门。');
insert into student values(0,'2024-2-25 10:00:00','易烊千玺','123',
'13453453453',24,'男','送你一朵小红花。');
insert into student values(0,'2024-2-25 10:00:00','丁禹兮','123',
'13453453453',29,'男','大理寺少卿游。');
insert into student values(0,'2024-2-25 10:00:00','成毅','123',
'13453453453',34,'男','莲花楼。');
insert into student values(0,'2024-2-25 10:00:00','吴磊','123',
'13453453453',25,'男','星汉灿烂。');
insert into student values(0,'2024-2-25 10:00:00','白敬亭','123',
'13453453453',31,'男','开端。');
查询语句
SELECT * FROM student where userName like '王_';
SELECT * FROM student where userName like '王%';
SELECT * FROM student where introduce like '%兮%';
select * from student where pwd is not null;
select * from student where age between 22 and 30;
select * from student where createDate BETWEEN '2024-02-21 00:00:00' and '2024-02-25 00:00:00';
select * from student where userName in('易烊千玺','吴磊','白敬亭');