mysql insert select

日常记录,mysql insert select写法:

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
insert into table_a (audit_id,command_no,cid) select audit_id,command_no,id from spamcenter.table_b;
insert into table_a (audit_id,command_no,cid) select audit_id,command_no,id from spamcenter.table_b;
insert into table_a (audit_id,command_no,cid) select audit_id,command_no,id from spamcenter.table_b;
120

0 评论
最新
最旧 最多投票
内联反馈
查看所有评论