mysql将语句写入表中

使用create table语句即可

CREATE TABLE membertmp
 (select a.* from member as a where a.phone <> '' and a.member_id not in (select member_id from master_audit) and a.member_id not in(select member_id from member_order));