select id from book MINUS select id from new;
凤凰涅槃 2010-05-18 10:51:02 book和new分别是两表;
select id from book where id in( select id from new);
返回结果id
1
11
但是输入标题sql语句时候,提示
you have an error in your sql syntax; check the manual that corresponds to your mysql server version for the right syntax to use near('select id from new') at line 1;