有时候需要些插入语句需要写字段名称，但由于字段很多所有比较麻烦。用以下的语句就可以直接把所有字段名称查出来直接用了
select GROUP_CONCAT(COLUMN_NAME) from information_schema.COLUMNS where table_name = 'activity_info';
合并不同数据库中相同的表：表id 增加100（这个数字根据表自身的大小来增加）
insert into saas_award_pool_redniu_integration.activity(Id,ActivityName,CreationTime,CreatorUserId,DeleterUserId,DeletionTime,Description,EndDateTime,HostCompany,IsActivated,IsDeleted,IsGeoRequired,IsVaild,LastModificationTime,LastModifierUserId,PublicAccountId,RuleDescription,ServicePhoneNumber,StartDateTime,TenantId,Url)select Id+100,ActivityName,CreationTime,CreatorUserId,DeleterUserId,DeletionTime,Description,EndDateTime,HostCompany,IsActivated,IsDeleted,IsGeoRequired,IsVaild,LastModificationTime,LastModifierUserId,PublicAccountId,RuleDescription,ServicePhoneNumber,StartDateTime,TenantId,Urlfrom saas_award_pool_redniu.activity
转载于:https://www.cnblogs.com/leegj/p/11551274.html
