INSERT IGNORE INTO lts.lp_coupon (SELECT CONCAT('(',GROUP_CONCAT(COLUMN_NAME SEPARATOR ','),')') FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'tmp_YqVxTy7w' AND TABLE_NAME = 'lp_coupon' GROUP BY TABLE_NAME limit 1) select * from tmp_YqVxTy7w.lp_coupon;