How to write an SQL query statement in MySQL

I am a cainiao

Table A has an ID field, and table B also has an ID field.

Table A does not exist and all records in Table B need to be filtered out.

(1) Select * From t_website_notemp where id not in (select ID from t_website );

 

(2) Select t_website_notemp. * From t_website_notemp left join t_website on t_website_notemp.id = t_website.id where t_website.id is null;

 

(3) Select * From t_website_notemp ID where not exists (select ID from t_website );

 

As for the specific performance, it cannot be said that nobody is absolutely high. It should be related to the data table size and so on.