把equip表符合条件的记录插入到equip_snapshot表
insert into equip_snapshot select * from equip where serial = 281479271677952 ;
返回所有信息,库gamedb的表equip的所有字段
SELECT * FROM `information_schema`.`columns` WHERE TABLE_NAME= 'equip' AND TABLE_SCHEMA='gamedb'
返回字段名,库gamedb的表equip的所有字段
SELECT column_Name FROM `information_schema`.`columns` WHERE TABLE_NAME= 'equip' AND TABLE_SCHEMA='gamedb'
拼接,查询到的字段名
SELECT GROUP_CONCAT(column_Name) FROM `information_schema`.`columns` WHERE TABLE_NAME= 'equip' AND TABLE_SCHEMA='gamedb'