mysql insert select

日常记录，mysql insert select写法:

insert into table_a (audit_id,command_no,cid) select audit_id,command_no,id from spamcenter.table_b;