CREATE DATABASE test; use test; CREATE TABLE student ( id int, name varchar(255), address varchar(255), city varchar(255) ); create table teaches ( id int, mame varchar(255) ); INSERT INTO student VALUES (1, '刘一', '郑十家隔壁', '河南'); INSERT INTO student VALUES (11, '朱元璋', 'peking', '河南'); INSERT INTO student VALUES (2, '陈二', 'peking', '安徽'); INSERT INTO student VALUES (3, '张三', '白娘子家隔壁', '杭州'); INSERT INTO student VALUES (4, '李四', '许仙家隔壁', '杭州'); INSERT INTO student VALUES (5, '王五', '李四家隔壁', '杭州'); INSERT INTO student VALUES (6, '赵六', '赵六家隔壁', '杭州'); INSERT INTO student VALUES (7, '孙七', '张三家隔壁', '杭州'); INSERT INTO student VALUES (8, '周八', '雷峰塔附近', '杭州'); INSERT INTO student VALUES (9, '吴九', '孙七家隔壁', '杭州'); INSERT INTO student VALUES (10, '郑十', '周八家隔壁', '杭州'); insert into teaches VALUES(1,'Mr.li'); (SELECT name FROM student ) intersect SELECT name from teaches ;为啥错了