查询表A内容插入表B并添加外部参数(your phoneNum) B表中没有phone字段 从外部传入
INSERT INTO lazymingshi_chongzhi(viptype,number,phone) SELECT type,number,'your phoneNum' FROM lazymingshi_number
查询表A内容插入表B并添加外部参数(your phoneNum) B表中没有phone字段 从外部传入
INSERT INTO lazymingshi_chongzhi(viptype,number,phone) SELECT type,number,'your phoneNum' FROM lazymingshi_number