Java学习-MySQL-DQL数据查询-模糊查询操作符
模糊查询操作符
运算符 |
语法 |
描述 |
IS NULL |
|
数据为空 |
IS NOT NULL |
|
数据不为空 |
BETWEEN b AND c |
a between b and c |
数据在a到b之间 |
Like |
a like b |
a匹配b |
In |
a in (a1,a2,a3,…) |
a在集合内 |
初始化
CREATE DATABASE IF NOT EXISTS `school`;
USE `school`;
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`(
`studentno` INT(4) NOT NULL COMMENT '学号',
`studentname` VARCHAR(20) DEFAULT NULL COMMENT '学生姓名',
`sex` TINYINT(1) DEFAULT NULL COMMENT '性别,0或1',
`gradeid` INT(11) DEFAULT NULL COMMENT '年级编号',
`address` VARCHAR(255) DEFAULT NULL COMMENT '地址,允许为空',
PRIMARY KEY (`studentno`)
)ENGINE=MYISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `grade`;
CREATE TABLE `grade`(
`gradeid` INT(11) NOT NULL AUTO_INCREMENT COMMENT '年级编号',
`gradename` VARCHAR(50) NOT NULL COMMENT '年级名称',
PRIMARY KEY (`gradeid`)
) ENGINE=INNODB AUTO_INCREMENT = 6 DEFAULT CHARSET = utf8;
DROP TABLE IF EXISTS `subject`;
CREATE TABLE `subject`<