语法
SELECT * FROM table
UNION [ALL | DISTINCT]
SELECT * FROM table
ALL全部数据 DISTINCT去重数据
例子
//结构
CREATE TABLE `user_student` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(10) NOT NULL,
`sex` tinyint(4) NOT NULL,
`tel` char(11) NOT NULL,
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
CREATE TABLE `user_teacher` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` varchar(10) NOT NULL,
`sex` tinyint(4) NOT NULL,
`tel` char(11) NOT NULL,
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARACTER SET utf8;
//查询全部数据
SELECT * FROM `user_student`
UNION All
SELECT * FROM `user_teacher`
//查询去重数据 DISTINCT可选
SELECT * FROM `user_student`
UNION DISTINCT
SELECT * FROM `user_teacher`