推荐:sql语句:SQLServer字段排序(按笔画,拼音,拼音首字母)--按笔画排序 select ChannelID,ChannelName from dbo.HB_AdChannel order by ChannelName collate chinese_prc_stroke_cs_as_ks_ws --按拼音排序 select ChannelID,ChannelName+Description from dbo.HB_AdChannel order by ChannelName+Description collate chinese_
对于MyISAM:
a.alter table table_name disable keys
b.loading data
c.alter table table_name enable keys
对于Innodb:
a.将要导入的数据按照主键排序
b.set unique_checks=0,关闭唯一性校验
c.set autocommit=0,关闭自动提交
分享:sql语句:拷贝表,复制表1.说明:复制表(只复制结构,源表名:a新表名:b) SQL:Select*INTObFROMaWhere11 2.说明:拷贝表(拷贝数据,源表名:a目标表名:b) SQL:InsertINTOb(a,b,c)Selectd,e,fFROMb