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;
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;
select `id` from book where `id` in( select `id` from `new`);
new 加上反引号`
还是没有结果的