For help -- MySQL enum data type

MySQL 5.1 reference document, enum () can have a maximum of 65535 enumeration value, but when I use the enumeration value is more than 5000, is wrong

Error Code: 1117. Too many columns

Test 4000 can still

Everyone who knows why

Started by Grover at December 15, 2016 - 3:45 AM

What is your create table statement?

Posted by Arvin at December 16, 2016 - 4:40 AM

I am using the alter table


ALTER TABLE `DicCity` CHANGE COLUMN `city` `city` ENUM('The city of Beijing','Tianjin city','The city of Shijiazhuang','Tangshan City','The city of Qinhuangdao','The city of Handan','The city of Xingtai','The city of Baoding','Zhangjiakou City','The city of Chengde','The city of Cangzhou','The city of Langfang','The city of Hengshui','The city of Taiyuan','Datong','The city of Yangquan','The city of Changzhi','The city of Jincheng','The city of Shuozhou','The city of Xinzhou','The city of Lvliang','The city of Jinzhong','The city of Linfen','The city of Yuncheng','The city of Shenyang','Dalian City','The city of Anshan','The city of Fushun','The city of Benxi','The city of Dandong','The city of Jinzhou','The city of Yingkou','The city of Fuxin','The city of Liaoyang','The city of Panjin','The city of Tieling','Chaoyang City','The city of Huludao','Changchun City','The city of Jilin','Siping City','The city of Liaoyuan','The city of Tonghua','Baishan City','The city of Songyuan','The city of Baicheng','The Yanbian Korean Autonomous Prefecture','The city of Harbin','The city of Qigihar','The city of Jixi','The city of Hegang','The city of Shuangyashan','The city of Daqing','The city of Yichun','The city of Qitaihe','The city of Mudanjiang','The city of Heihe','The city of Suihua','Greater Khingan Range area','The city of Shanghai','The city of Nanjing','The city of Wuxi','The city of Xuzhou','The city of Changzhou','The city of Suzhou','The city of Nantong','Lianyungang City','The city of Huaiyin','Yancheng City','The city of Yangzhou','The city of Zhenjiang','The city of Taizhou','The city of Suqian','The city of Hangzhou','The city of Ningbo','The city of Wenzhou','The city of Jiaxing','The city of Huzhou','The city of Shaoxing','The city of Jinhua','The city of Quzhou','The city of Zhoushan','The city of Taizhou','The city of Lishui','Hefei City','The city of Wuhu','The city of Bengbu','The city of Huainan','The city of Ma'anshan','The city of Huaibei','The city of Tongling','The city of Anqing','Huangshan City','The city of Chuzhou','The city of Fuyang','The city of Suzhou','The city of Lu'an','The city of Xuancheng','The city of Chaohu','The city of Chizhou','The city of Fuzhou','The city of Xiamen','The city of Ningde','The city of Putian','The city of Quanzhou','The city of Zhangzhou','The city of Longyan','Sanming City','The city of Nanping','Nanchang City','The city of Jingdezhen','The city of Pingxiang','Jiujiang','The city of Xinyu','The city of Yingtan','The city of Ganzhou','The city of Yichun','The city of Shangrao','The city of Ji'an','The city of Fuzhou','The city of Ji'nan','The city of Qingdao','The city of Zibo','The city of Zaozhuang','The city of Dongying','The city of Yantai','The city of Weifang','The city of Jining','The city of Tai'an','The city of Weihai','Rizhao City','The city of Laiwu','The city of Linyi','The city of Dezhou','The city of Liaocheng','Binzhou area','Heze area','The city of Zhengzhou','The city of Kaifeng','The city of Luoyang','The city of Pingdingshan','The city of Anyang','The city of Hebi','The city of Xinxiang','The city of Jiaozuo','The city of Puyang','The city of Xuchang','The city of Luohe','The city of Sanmenxia','The city of Nanyang','The city of Shangqiu','The city of Xinyang','The city of Zhoukou','Zhumadian area','The city of Jiyuan','Changsha City','The city of Zhuzhou','The city of Xiangtan','The city of Hengyang','The city of Shaoyang','The city of Yueyang','The city of Changde','The city of Zhangjiajie','The city of Yiyang','The city of Chenzhou','The city of Yongzhou','The city of Huaihua','Loudi area','Tujia and Miao Autonomous Prefecture of Xiangxi','The city of Zhuhai','The city of Haikou','The city of Sanya','The city of Chongqing','Chengdu City','The city of Zigong','The city of Panzhihua','The city of Luzhou','The city of Deyang','The city of Mianyang','The city of Guangyuan','The city of Suining','The city of Neijiang','The city of Leshan','The city of Nanchong','The city of Yibin','The city of Guang'an','Da Chuan area','Ya'an area','Aba Tibetan and Qiang Autonomous Prefecture','Ganzi Tibetan Autonomous Prefecture','Liangshan Yi Autonomous Prefecture','Bazhong area','Meishan area','Ziyang area','Guiyang City','The city of Liupanshui','The city of Zunyi','Tongren area','Buyi and Miao Autonomous Prefecture in southwestern Guizhou','Bijie area','Anshun area','Qiandongnan Miao and Dong Autonomous Prefecture','Buyi and Miao Autonomous Prefecture of Qiannan','The city of Kunming','The city of Qujing','The city of Yuxi','Zhaotong area','Chuxiong Yi Autonomous Prefecture','Honghe Hani and Yi Autonomous Prefecture','Wenshan Zhuang and Miao Autonomous Prefecture','The city of Simao','Xishuangbanna Dai Autonomous Prefecture','Dali Bai Nationality Autonomous Prefecture','Baoshan area','Dehong Dai Jingpo Autonomous Prefecture','Lijiang area','Nu River Lisu Autonomous Prefecture','Diqing Tibetan Autonomous Prefecture','Lincang area','Xi'an City','The city of Tongchuan','The city of Baoji','The city of Xianyang','The city of Weinan','The city of Yanan','The city of Hanzhoung','Ankang area','Shangluo area','Yulin area','The city of Lanzhou','Jiayuguan City','The city of Jinchang','Baiyin','Tianshui','Jiuquan area','Zhangye area','Wuwei area','Dingxi area','Longnan area','Pingliang area','Qingyang area','Linxia Hui Autonomous Prefecture','Gannan Tibetan Autonomous Prefecture','The city of Xining','Haidong Prefecture','Haibei Tibetan Autonomous Prefecture','Huangnan Tibetan Autonomous Prefecture','Hainan Tibetan Autonomous Prefecture','Golog Tibetan Autonomous Prefecture','Yushu Tibetan Autonomous Prefecture','The Mongolia Tibetan Autonomous Prefecture of Haixi state','Wuhan City','The city of Huangshi','The city of Shiyan','The city of Yichang','The city of Xiangfan','The city of Ezhou','The city of Jingmen','The city of Xiaogan','The city of Jingzhou','The city of Huanggang','The city of Xianning','Tujia and Miao Autonomous Prefecture of Enshi','The city of Guangzhou','The city of Shaoguan','The city of Shenzhen','The city of Shantou','Foshan City','The city of Jiangmen','The city of Zhanjiang','The city of Maoming','The city of Zhaoqing','The city of Huizhou','The city of Meizhou','The city of Shanwei','The city of Heyuan','The city of Yangjiang','The city of Qingyuan','The city of Dongguan','The city of Zhongshan','The city of Chaozhou','The city of Jieyang','The city of Yunfu','Hohhot City','The city of Baotou','The city of Wuhai','The city of Chifeng','The city of Hulun Buir','Xingan Meng','The city of Tongliao','Xilinguole Meng','The Wulanchabu League','In','The Bayannaoer League','Alxa League','Nanning City','The city of Liuzhou','The city of Guilin','The city of Wuzhou','The city of Beihai','The city of Fangchenggang','The city of Qinzhou','Guigang City','The city of Yulin','The city of Chongzuo','Laibin City','The city of Hezhou','Baise','The city of Hechi','The city of Lhasa','Changdu area','Shannan Area','Shigatse area','Nagqu area','Ali Area','Linzhi area','The city of Yinchuan','The city of Shizuishan','Wu Zhongshi','Guyuan area','The city of Zhongwei','The city of Urumqi','Karamay City','Turpan area','Hami area','Changji Hui Autonomous Prefecture','Bortala Mongolia Autonomous Prefecture','Bayinguoleng Mongolia Autonomous Prefecture','Akesu area','Kizilsu Kirgiz Autonomous Prefecture','Kashi area','Hetian Area','Yili Kazak Autonomous Prefecture','Tacheng area','Aletai area','The Hongkong Special Administrative Region','The Macao Special Administrative Region','Taiwan area','The city of Shihezi','Alar City','Tumushuke City','Wujiaqu City','Xiantao','The city of Qianjiang','Tianmen','Shennongjia Forest Region','The city of Danzhou','The city of Five Fingers Group','The city of Wenchang','The city of Wanning','Oriental City','Ding'an County','Tunchang County','Chengmai County','Lingao County','Baisha Li Autonomous County','Changjiang Li Autonomous County','Ledong Li Autonomous County','Lingshui Li Autonomous County','Li and Miao Autonomous County of Baoting','Qiongzhong Li and Miao Autonomous County','Southwest Zhongsha Islands Office','The city of Beijing1','The city of Beijing2','The city of Beijing3','The city of Beijing4','The city of Beijing5','The city of Beijing6','The city of Beijing7','The city of Beijing8','The city of Beijing9','The city of Beijing10','The city of Beijing11','The city of Beijing12','The city of Beijing13','The city of Beijing14','The city of Beijing15','The city of Beijing16','The city of Beijing17','The city of Beijing18','The city of Beijing19','The city of Beijing20','The city of Beijing21','The city of Beijing22','The city of Beijing23','The city of Beijing24','The city of Beijing25','The city of Beijing26','The city of Beijing27','The city of Beijing28','The city of Beijing29','The city of Beijing30','The city of Beijing31','The city of Beijing32','The city of Beijing33','The city of Beijing34','The city of Beijing35','The city of Beijing36','The city of Beijing37','The city of Beijing38','The city of Beijing39','The city of Beijing40','The city of Beijing41','The city of Beijing42','The city of Beijing43','The city of Beijing44','The city of Beijing45','The city of Beijing46','The city of Beijing47','The city of Beijing48','The city of Beijing49','The city of Beijing50','The city of Beijing51','The city of Beijing52','The city of Beijing53','The city of Beijing54','The city of Beijing55','The city of Beijing56','The city of Beijing57','The city of Beijing58','The city of Beijing59','The city of Beijing60','The city of Beijing61','The city of Beijing62','The city of Beijing63','The city of Beijing64','The city of Beijing65','The city of Beijing66','The city of Beijing67','The city of Beijing68','The city of Beijing69','The city of Beijing70','The city of Beijing71','The city of Beijing72','The city of Beijing73','The city of Beijing74','The city of Beijing75','The city of Beijing76','The city of Beijing77','The city of Beijing78','The city of Beijing79','The city of Beijing80','The city of Beijing81','The city of Beijing82','The city of Beijing83','The city of Beijing84','The city of Beijing85','The city of Beijing86','The city of Beijing87','The city of Beijing88','The city of Beijing89','The city of Beijing90','The city of Beijing91','The city of Beijing92','The city of Beijing93','The city of Beijing94','The city of Beijing95','The city of Beijing96','The city of Beijing97','The city of Beijing98','The city of Beijing99','The city of Beijing100','The city of Beijing101','The city of Beijing102','The city of Beijing103','The city of Beijing104','The city of Beijing105','The city of Beijing106','The city of Beijing107','The city of Beijing108','The city of Beijing109','The city of Beijing110','The city of Beijing111','The city of Beijing112','The city of Beijing113','The city of Beijing114','The city of Beijing115','The city of Beijing116','The city of Beijing117','The city of Beijing118','The city of Beijing119','The city of Beijing120','The city of Beijing121','The city of Beijing122','The city of Beijing123','The city of Beijing124','The city of Beijing125','The city of Beijing126','The city of Beijing127','The city of Beijing128','The city of Beijing129','The city of Beijing130','The city of Beijing131','The city of Beijing132','The city of Beijing133','The city of Beijing134','The city of Beijing135','The city of Beijing136','The city of Beijing137','The city of Beijing138','The city of Beijing139','The city of Beijing140','The city of Beijing141','The city of Beijing142','The city of Beijing143','The city of Beijing144','The city of Beijing145','The city of Beijing146','The city of Beijing147','The city of Beijing148','The city of Beijing149','The city of Beijing150','The city of Beijing151','The city of Beijing152','The city of Beijing153','The city of Beijing154','The city of Beijing155','The city of Beijing156','The city of Beijing157','The city of Beijing158','The city of Beijing159','The city of Beijing160','The city of Beijing161','The city of Beijing162','The city of Beijing163','The city of Beijing164','The city of Beijing165','The city of Beijing166','The city of Beijing167','The city of Beijing168','The city of Beijing169','The city of Beijing170','The city of Beijing171','The city of Beijing172','The city of Beijing173','The city of Beijing174','The city of Beijing175','The city of Beijing176','The city of Beijing177','The city of Beijing178','The city of Beijing179','The city of Beijing180','The city of Beijing181','The city of Beijing182','The city of Beijing183','The city of Beijing184','The city of Beijing185','The city of Beijing186','The city of Beijing187','The city of Beijing188','The city of Beijing189','The city of Beijing190','The city of Beijing191','The city of Beijing192','The city of Beijing193','The city of Beijing194','The city of Beijing195','The city of Beijing196','The city of Beijing197','The city of Beijing198','The city of Beijing199','The city of Beijing200','The city of Beijing201','The city of Beijing202','The city of Beijing203','The city of Beijing204','The city of Beijing205','The city of Beijing206','The city of Beijing207','The city of Beijing208','The city of Beijing209','The city of Beijing210','The city of Beijing211','The city of Beijing212','The city of Beijing213','The city of Beijing214','The city of Beijing215','The city of Beijing216','The city of Beijing217','The city of Beijing218','The city of Beijing219','The city of Beijing220','The city of Beijing221','The city of Beijing222','The city of Beijing223','The city of Beijing224','The city of Beijing225','The city of Beijing226','The city of Beijing227','The city of Beijing228','The city of Beijing229','The city of Beijing230','The city of Beijing231','The city of Beijing232','The city of Beijing233','The city of Beijing234','The city of Beijing235','The city of Beijing236','The city of Beijing237','The city of Beijing238','The city of Beijing239','The city of Beijing240','The city of Beijing241','The city of Beijing242','The city of Beijing243','The city of Beijing244','The city of Beijing245','The city of Beijing246','The city of Beijing247','The city of Beijing248','The city of Beijing249','The city of Beijing250','The city of Beijing251','The city of Beijing252','The city of Beijing253','The city of Beijing254','The city of Beijing255','The city of Beijing256','The city of Beijing257','The city of Beijing258','The city of Beijing259','The city of Beijing260','The city of Beijing261','The city of Beijing262','The city of Beijing263','The city of Beijing264','The city of Beijing265','The city of Beijing266','The city of Beijing267','The city of Beijing268','The city of Beijing269','The city of Beijing270','The city of Beijing271','The city of Beijing272','The city of Beijing273','The city of Beijing274','The city of Beijing275','The city of Beijing276','The city of Beijing277','The city of Beijing278','The city of Beijing279','The city of Beijing280','The city of Beijing281','The city of Beijing282','The city of Beijing283','The city of Beijing284','The city of Beijing285','The city of Beijing286','The city of Beijing287','The city of Beijing288','The city of Beijing289','The city of Beijing290','The city of Beijing291','The city of Beijing292','The city of Beijing293','The city of Beijing294','The city of Beijing295','The city of Beijing296','The city of Beijing297','The city of Beijing298','The city of Beijing299','The city of Beijing300','The city of Beijing301','The city of Beijing302','The city of Beijing303','The city of Beijing304','The city of Beijing305','The city of Beijing306','The city of Beijing307','The city of Beijing308','The city of Beijing309','The city of Beijing310','The city of Beijing311','The city of Beijing312','The city of Beijing313','The city of Beijing314','The city of Beijing315','The city of Beijing316','The city of Beijing317','The city of Beijing318','The city of Beijing319','The city of Beijing320','The city of Beijing321','The city of Beijing322','The city of Beijing323','The city of Beijing324','The city of Beijing325','The city of Beijing326','The city of Beijing327','The city of Beijing328','The city of Beijing329','The city of Beijing330','The city of Beijing331','The city of Beijing332','The city of Beijing333','The city of Beijing334','The city of Beijing335','The city of Beijing336','The city of Beijing337','The city of Beijing338','The city of Beijing339','The city of Beijing340','The city of Beijing341','The city of Beijing342','The city of Beijing343','The city of Beijing344','The city of Beijing345','The city of Beijing346','The city of Beijing347','The city of Beijing348','The city of Beijing349','The city of Beijing350','The city of Beijing351','The city of Beijing352','The city of Beijing353','The city of Beijing354','The city of Beijing355','The city of Beijing356','The city of Beijing357','The city of Beijing358','The city of Beijing359','The city of Beijing360','The city of Beijing361','The city of Beijing362','The city of Beijing363','The city of Beijing364','The city of Beijing365','The city of Beijing366','The city of Beijing367','The city of Beijing368','The city of Beijing369','The city of Beijing370','The city of Beijing371','The city of Beijing372','The city of Beijing373','The city of Beijing374','The city of Beijing375','The city of Beijing376','The city of Beijing377','The city of Beijing378','The city of Beijing379','The city of Beijing380','The city of Beijing381','The city of Beijing382','The city of Beijing383','The city of Beijing384','The city of Beijing385','The city of Beijing386','The city of Beijing387','The city of Beijing388','The city of Beijing389','The city of Beijing390','The city of Beijing391','The city of Beijing392','The city of Beijing393','The city of Beijing394','The city of Beijing395','The city of Beijing396','The city of Beijing397','The city of Beijing398','The city of Beijing399','The city of Beijing400','The city of Beijing401','The city of Beijing402','The city of Beijing403','The city of Beijing404','The city of Beijing405','The city of Beijing406','The city of Beijing407','The city of Beijing408','The city of Beijing409','The city of Beijing410','The city of Beijing411','The city of Beijing412','The city of Beijing413','The city of Beijing414','The city of Beijing415','The city of Beijing416','The city of Beijing417','The city of Beijing418','The city of Beijing419','The city of Beijing420','The city of Beijing421','The city of Beijing422','The city of Beijing423','The city of Beijing424','The city of Beijing425','The city of Beijing426','The city of Beijing427','The city of Beijing428','The city of Beijing429','The city of Beijing430','The city of Beijing431','The city of Beijing432','The city of Beijing433','The city of Beijing434','The city of Beijing435','The city of Beijing436','The city of Beijing437','The city of Beijing438','The city of Beijing439','The city of Beijing440','The city of Beijing441','The city of Beijing442','The city of Beijing443','The city of Beijing444','The city of Beijing445','The city of Beijing446','The city of Beijing447','The city of Beijing448','The city of Beijing449','The city of Beijing450','The city of Beijing451','The city of Beijing452','The city of Beijing453','The city of Beijing454','The city of Beijing455','The city of Beijing456','The city of Beijing457','The city of Beijing458','The city of Beijing459','The city of Beijing460','The city of Beijing461','The city of Beijing462','The city of Beijing463','The city of Beijing464','The city of Beijing465','The city of Beijing466','The city of Beijing467','The city of Beijing468','The city of Beijing469','The city of Beijing470','The city of Beijing471','The city of Beijing472','The city of Beijing473','The city of Beijing474','The city of Beijing475','The city of Beijing476','The city of Beijing477','The city of Beijing478','The city of Beijing479','The city of Beijing480','The city of Beijing481','The city of Beijing482','The city of Beijing483','The city of Beijing484','The city of Beijing485','The city of Beijing486','The city of Beijing487','The city of Beijing488','The city of Beijing489','The city of Beijing490','The city of Beijing491','The city of Beijing492','The city of Beijing493','The city of Beijing494','The city of Beijing495','The city of Beijing496','The city of Beijing497','The city of Beijing498','The city of Beijing499','The city of Beijing500','The city of Beijing501','The city of Beijing502','The city of Beijing503','The city of Beijing504','The city of Beijing505','The city of Beijing506','The city of Beijing507','The city of Beijing508','The city of Beijing509','The city of Beijing510','The city of Beijing511','The city of Beijing512','The city of Beijing513','The city of Beijing514','The city of Beijing515','The city of Beijing516','The city of Beijing517','The city of Beijing518','The city of Beijing519','The city of Beijing520','The city of Beijing521','The city of Beijing522','The city of Beijing523','The city of Beijing524','The city of Beijing525','The city of Beijing526','The city of Beijing527','The city of Beijing528','The city of Beijing529','The city of Beijing530','The city of Beijing531','The city of Beijing532','The city of Beijing533','The city of Beijing534','The city of Beijing535','The city of Beijing536','The city of Beijing537','The city of Beijing538','The city of Beijing539','The city of Beijing540','The city of Beijing541','The city of Beijing542','The city of Beijing543','The city of Beijing544','The city of Beijing545','The city of Beijing546','The city of Beijing547','The city of Beijing548','The city of Beijing549','The city of Beijing550','The city of Beijing551','The city of Beijing552','The city of Beijing553','The city of Beijing554','The city of Beijing555','The city of Beijing556','The city of Beijing557','The city of Beijing558','The city of Beijing559','The city of Beijing560','The city of Beijing561','The city of Beijing562','The city of Beijing563','The city of Beijing564','The city of Beijing565','The city of Beijing566','The city of Beijing567','The city of Beijing568','The city of Beijing569','The city of Beijing570','The city of Beijing571','The city of Beijing572','The city of Beijing573','The city of Beijing574','The city of Beijing575','The city of Beijing576','The city of Beijing577','The city of Beijing578','The city of Beijing579','The city of Beijing580','The city of Beijing581','The city of Beijing582','The city of Beijing583','The city of Beijing584','The city of Beijing585','The city of Beijing586','The city of Beijing587','The city of Beijing588','The city of Beijing589','The city of Beijing590','The city of Beijing591','The city of Beijing592','The city of Beijing593','The city of Beijing594','The city of Beijing595','The city of Beijing596','The city of Beijing597','The city of Beijing598','The city of Beijing599','The city of Beijing600','The city of Beijing601','The city of Beijing602','The city of Beijing603','The city of Beijing604','The city of Beijing605','The city of Beijing606','The city of Beijing607','The city of Beijing608','The city of Beijing609','The city of Beijing610','The city of Beijing611','The city of Beijing612','The city of Beijing613','The city of Beijing614','The city of Beijing615','The city of Beijing616','The city of Beijing617','The city of Beijing618','The city of Beijing619','The city of Beijing620','The city of Beijing621','The city of Beijing622','The city of Beijing623','The city of Beijing624','The city of Beijing625','The city of Beijing626','The city of Beijing627','The city of Beijing628','The city of Beijing629','The city of Beijing630','The city of Beijing631','The city of Beijing632','The city of Beijing633','The city of Beijing634','The city of Beijing635','The city of Beijing636','The city of Beijing637','The city of Beijing638','The city of Beijing639','The city of Beijing640','The city of Beijing641','The city of Beijing642','The city of Beijing643','The city of Beijing644','The city of Beijing645','The city of Beijing646','The city of Beijing647','The city of Beijing648','The city of Beijing649','The city of Beijing650','The city of Beijing651','The city of Beijing652','The city of Beijing653','The city of Beijing654','The city of Beijing655','The city of Beijing656','The city of Beijing657','The city of Beijing658','The city of Beijing659','The city of Beijing660','The city of Beijing661','The city of Beijing662','The city of Beijing663','The city of Beijing664','The city of Beijing665','The city of Beijing666','The city of Beijing667','The city of Beijing668','The city of Beijing669','The city of Beijing670','The city of Beijing671','The city of Beijing672'.....csdn The text editor limit10000The characters are following) NULL DEFAULT NULL ;

Posted by Grover at December 29, 2016 - 5:04 AM

I am using the alter table


ALTER TABLE `DicCity` CHANGE COLUMN `city` `city` ENUM('The city of Beijing','Tianjin city','The city of Shijiazhuang','Tangshan City','The city of Qinhuangdao','The city of Handan','The city of Xingtai','The city of Baoding','Zhangjiakou City','The city of Chengde','The city of Cangzhou','The city of Langfang','The city of Hengshui','The city of Taiyuan','Datong','The city of Yangquan','The city of Changzhi','The city of Jincheng','The city of Shuozhou','The city of Xinzhou','The city of Lvliang','The city of Jinzhong','The city of Linfen','The city of Yuncheng','The city of Shenyang','Dalian City','The city of Anshan','The city of Fushun','The city of Benxi','The city of Dandong','The city of Jinzhou','The city of Yingkou','The city of Fuxin','The city of Liaoyang','The city of Panjin','The city of Tieling','Chaoyang City','The city of Huludao','Changchun City','The city of Jilin','Siping City','The city of Liaoyuan','The city of Tonghua','Baishan City','The city of Songyuan','The city of Baicheng','The Yanbian Korean Autonomous Prefecture','The city of Harbin','The city of Qigihar','The city of Jixi','The city of Hegang','The city of Shuangyashan','The city of Daqing','The city of Yichun','The city of Qitaihe','The city of Mudanjiang','The city of Heihe','The city of Suihua','Greater Khingan Range area','The city of Shanghai','The city of Nanjing','The city of Wuxi','The city of Xuzhou','The city of Changzhou','The city of Suzhou','The city of Nantong','Lianyungang City','The city of Huaiyin','Yancheng City','The city of Yangzhou','The city of Zhenjiang','The city of Taizhou','The city of Suqian','The city of Hangzhou','The city of Ningbo','The city of Wenzhou','The city of Jiaxing','The city of Huzhou','The city of Shaoxing','The city of Jinhua','The city of Quzhou','The city of Zhoushan','The city of Taizhou','The city of Lishui','Hefei City','The city of Wuhu','The city of Bengbu','The city of Huainan','The city of Ma'anshan','The city of Huaibei','The city of Tongling','The city of Anqing','Huangshan City','The city of Chuzhou','The city of Fuyang','The city of Suzhou','The city of Lu'an','The city of Xuancheng','The city of Chaohu','The city of Chizhou','The city of Fuzhou','The city of Xiamen','The city of Ningde','The city of Putian','The city of Quanzhou','The city of Zhangzhou','The city of Longyan','Sanming City','The city of Nanping','Nanchang City','The city of Jingdezhen','The city of Pingxiang','Jiujiang','The city of Xinyu','The city of Yingtan','The city of Ganzhou','The city of Yichun','The city of Shangrao','The city of Ji'an','The city of Fuzhou','The city of Ji'nan','The city of Qingdao','The city of Zibo','The city of Zaozhuang','The city of Dongying','The city of Yantai','The city of Weifang','The city of Jining','The city of Tai'an','The city of Weihai','Rizhao City','The city of Laiwu','The city of Linyi','The city of Dezhou','The city of Liaocheng','Binzhou area','Heze area','The city of Zhengzhou','The city of Kaifeng','The city of Luoyang','The city of Pingdingshan','The city of Anyang','The city of Hebi','The city of Xinxiang','The city of Jiaozuo','The city of Puyang','The city of Xuchang','The city of Luohe','The city of Sanmenxia','The city of Nanyang','The city of Shangqiu','The city of Xinyang','The city of Zhoukou','Zhumadian area','The city of Jiyuan','Changsha City','The city of Zhuzhou','The city of Xiangtan','The city of Hengyang','The city of Shaoyang','The city of Yueyang','The city of Changde','The city of Zhangjiajie','The city of Yiyang','The city of Chenzhou','The city of Yongzhou','The city of Huaihua','Loudi area','Tujia and Miao Autonomous Prefecture of Xiangxi','The city of Zhuhai','The city of Haikou','The city of Sanya','The city of Chongqing','Chengdu City','The city of Zigong','The city of Panzhihua','The city of Luzhou','The city of Deyang','The city of Mianyang','The city of Guangyuan','The city of Suining','The city of Neijiang','The city of Leshan','The city of Nanchong','The city of Yibin','The city of Guang'an','Da Chuan area','Ya'an area','Aba Tibetan and Qiang Autonomous Prefecture','Ganzi Tibetan Autonomous Prefecture','Liangshan Yi Autonomous Prefecture','Bazhong area','Meishan area','Ziyang area','Guiyang City','The city of Liupanshui','The city of Zunyi','Tongren area','Buyi and Miao Autonomous Prefecture in southwestern Guizhou','Bijie area','Anshun area','Qiandongnan Miao and Dong Autonomous Prefecture','Buyi and Miao Autonomous Prefecture of Qiannan','The city of Kunming','The city of Qujing','The city of Yuxi','Zhaotong area','Chuxiong Yi Autonomous Prefecture','Honghe Hani and Yi Autonomous Prefecture','Wenshan Zhuang and Miao Autonomous Prefecture','The city of Simao','Xishuangbanna Dai Autonomous Prefecture','Dali Bai Nationality Autonomous Prefecture','Baoshan area','Dehong Dai Jingpo Autonomous Prefecture','Lijiang area','Nu River Lisu Autonomous Prefecture','Diqing Tibetan Autonomous Prefecture','Lincang area','Xi'an City','The city of Tongchuan','The city of Baoji','The city of Xianyang','The city of Weinan','The city of Yanan','The city of Hanzhoung','Ankang area','Shangluo area','Yulin area','The city of Lanzhou','Jiayuguan City','The city of Jinchang','Baiyin','Tianshui','Jiuquan area','Zhangye area','Wuwei area','Dingxi area','Longnan area','Pingliang area','Qingyang area','Linxia Hui Autonomous Prefecture','Gannan Tibetan Autonomous Prefecture','The city of Xining','Haidong Prefecture','Haibei Tibetan Autonomous Prefecture','Huangnan Tibetan Autonomous Prefecture','Hainan Tibetan Autonomous Prefecture','Golog Tibetan Autonomous Prefecture','Yushu Tibetan Autonomous Prefecture','The Mongolia Tibetan Autonomous Prefecture of Haixi state','Wuhan City','The city of Huangshi','The city of Shiyan','The city of Yichang','The city of Xiangfan','The city of Ezhou','The city of Jingmen','The city of Xiaogan','The city of Jingzhou','The city of Huanggang','The city of Xianning','Tujia and Miao Autonomous Prefecture of Enshi','The city of Guangzhou','The city of Shaoguan','The city of Shenzhen','The city of Shantou','Foshan City','The city of Jiangmen','The city of Zhanjiang','The city of Maoming','The city of Zhaoqing','The city of Huizhou','The city of Meizhou','The city of Shanwei','The city of Heyuan','The city of Yangjiang','The city of Qingyuan','The city of Dongguan','The city of Zhongshan','The city of Chaozhou','The city of Jieyang','The city of Yunfu','Hohhot City','The city of Baotou','The city of Wuhai','The city of Chifeng','The city of Hulun Buir','Xingan Meng','The city of Tongliao','Xilinguole Meng','The Wulanchabu League','In','The Bayannaoer League','Alxa League','Nanning City','The city of Liuzhou','The city of Guilin','The city of Wuzhou','The city of Beihai','The city of Fangchenggang','The city of Qinzhou','Guigang City','The city of Yulin','The city of Chongzuo','Laibin City','The city of Hezhou','Baise','The city of Hechi','The city of Lhasa','Changdu area','Shannan Area','Shigatse area','Nagqu area','Ali Area','Linzhi area','The city of Yinchuan','The city of Shizuishan','Wu Zhongshi','Guyuan area','The city of Zhongwei','The city of Urumqi','Karamay City','Turpan area','Hami area','Changji Hui Autonomous Prefecture','Bortala Mongolia Autonomous Prefecture','Bayinguoleng Mongolia Autonomous Prefecture','Akesu area','Kizilsu Kirgiz Autonomous Prefecture','Kashi area','Hetian Area','Yili Kazak Autonomous Prefecture','Tacheng area','Aletai area','The Hongkong Special Administrative Region','The Macao Special Administrative Region','Taiwan area','The city of Shihezi','Alar City','Tumushuke City','Wujiaqu City','Xiantao','The city of Qianjiang','Tianmen','Shennongjia Forest Region','The city of Danzhou','The city of Five Fingers Group','The city of Wenchang','The city of Wanning','Oriental City','Ding'an County','Tunchang County','Chengmai County','Lingao County','Baisha Li Autonomous County','Changjiang Li Autonomous County','Ledong Li Autonomous County','Lingshui Li Autonomous County','Li and Miao Autonomous County of Baoting','Qiongzhong Li and Miao Autonomous County','Southwest Zhongsha Islands Office','The city of Beijing1','The city of Beijing2','The city of Beijing3','The city of Beijing4','The city of Beijing5','The city of Beijing6','The city of Beijing7','The city of Beijing8','The city of Beijing9','The city of Beijing10','The city of Beijing11','The city of Beijing12','The city of Beijing13','The city of Beijing14','The city of Beijing15','The city of Beijing16','The city of Beijing17','The city of Beijing18','The city of Beijing19','The city of Beijing20','The city of Beijing21','The city of Beijing22','The city of Beijing23','The city of Beijing24','The city of Beijing25','The city of Beijing26','The city of Beijing27','The city of Beijing28','The city of Beijing29','The city of Beijing30','The city of Beijing31','The city of Beijing32','The city of Beijing33','The city of Beijing34','The city of Beijing35','The city of Beijing36','The city of Beijing37','The city of Beijing38','The city of Beijing39','The city of Beijing40','The city of Beijing41','The city of Beijing42','The city of Beijing43','The city of Beijing44','The city of Beijing45','The city of Beijing46','The city of Beijing47','The city of Beijing48','The city of Beijing49','The city of Beijing50','The city of Beijing51','The city of Beijing52','The city of Beijing53','The city of Beijing54','The city of Beijing55','The city of Beijing56','The city of Beijing57','The city of Beijing58','The city of Beijing59','The city of Beijing60','The city of Beijing61','The city of Beijing62','The city of Beijing63','The city of Beijing64','The city of Beijing65','The city of Beijing66','The city of Beijing67','The city of Beijing68','The city of Beijing69','The city of Beijing70','The city of Beijing71','The city of Beijing72','The city of Beijing73','The city of Beijing74','The city of Beijing75','The city of Beijing76','The city of Beijing77','The city of Beijing78','The city of Beijing79','The city of Beijing80','The city of Beijing81','The city of Beijing82','The city of Beijing83','The city of Beijing84','The city of Beijing85','The city of Beijing86','The city of Beijing87','The city of Beijing88','The city of Beijing89','The city of Beijing90','The city of Beijing91','The city of Beijing92','The city of Beijing93','The city of Beijing94','The city of Beijing95','The city of Beijing96','The city of Beijing97','The city of Beijing98','The city of Beijing99','The city of Beijing100','The city of Beijing101','The city of Beijing102','The city of Beijing103','The city of Beijing104','The city of Beijing105','The city of Beijing106','The city of Beijing107','The city of Beijing108','The city of Beijing109','The city of Beijing110','The city of Beijing111','The city of Beijing112','The city of Beijing113','The city of Beijing114','The city of Beijing115','The city of Beijing116','The city of Beijing117','The city of Beijing118','The city of Beijing119','The city of Beijing120','The city of Beijing121','The city of Beijing122','The city of Beijing123','The city of Beijing124','The city of Beijing125','The city of Beijing126','The city of Beijing127','The city of Beijing128','The city of Beijing129','The city of Beijing130','The city of Beijing131','The city of Beijing132','The city of Beijing133','The city of Beijing134','The city of Beijing135','The city of Beijing136','The city of Beijing137','The city of Beijing138','The city of Beijing139','The city of Beijing140','The city of Beijing141','The city of Beijing142','The city of Beijing143','The city of Beijing144','The city of Beijing145','The city of Beijing146','The city of Beijing147','The city of Beijing148','The city of Beijing149','The city of Beijing150','The city of Beijing151','The city of Beijing152','The city of Beijing153','The city of Beijing154','The city of Beijing155','The city of Beijing156','The city of Beijing157','The city of Beijing158','The city of Beijing159','The city of Beijing160','The city of Beijing161','The city of Beijing162','The city of Beijing163','The city of Beijing164','The city of Beijing165','The city of Beijing166','The city of Beijing167','The city of Beijing168','The city of Beijing169','The city of Beijing170','The city of Beijing171','The city of Beijing172','The city of Beijing173','The city of Beijing174','The city of Beijing175','The city of Beijing176','The city of Beijing177','The city of Beijing178','The city of Beijing179','The city of Beijing180','The city of Beijing181','The city of Beijing182','The city of Beijing183','The city of Beijing184','The city of Beijing185','The city of Beijing186','The city of Beijing187','The city of Beijing188','The city of Beijing189','The city of Beijing190','The city of Beijing191','The city of Beijing192','The city of Beijing193','The city of Beijing194','The city of Beijing195','The city of Beijing196','The city of Beijing197','The city of Beijing198','The city of Beijing199','The city of Beijing200','The city of Beijing201','The city of Beijing202','The city of Beijing203','The city of Beijing204','The city of Beijing205','The city of Beijing206','The city of Beijing207','The city of Beijing208','The city of Beijing209','The city of Beijing210','The city of Beijing211','The city of Beijing212','The city of Beijing213','The city of Beijing214','The city of Beijing215','The city of Beijing216','The city of Beijing217','The city of Beijing218','The city of Beijing219','The city of Beijing220','The city of Beijing221','The city of Beijing222','The city of Beijing223','The city of Beijing224','The city of Beijing225','The city of Beijing226','The city of Beijing227','The city of Beijing228','The city of Beijing229','The city of Beijing230','The city of Beijing231','The city of Beijing232','The city of Beijing233','The city of Beijing234','The city of Beijing235','The city of Beijing236','The city of Beijing237','The city of Beijing238','The city of Beijing239','The city of Beijing240','The city of Beijing241','The city of Beijing242','The city of Beijing243','The city of Beijing244','The city of Beijing245','The city of Beijing246','The city of Beijing247','The city of Beijing248','The city of Beijing249','The city of Beijing250','The city of Beijing251','The city of Beijing252','The city of Beijing253','The city of Beijing254','The city of Beijing255','The city of Beijing256','The city of Beijing257','The city of Beijing258','The city of Beijing259','The city of Beijing260','The city of Beijing261','The city of Beijing262','The city of Beijing263','The city of Beijing264','The city of Beijing265','The city of Beijing266','The city of Beijing267','The city of Beijing268','The city of Beijing269','The city of Beijing270','The city of Beijing271','The city of Beijing272','The city of Beijing273','The city of Beijing274','The city of Beijing275','The city of Beijing276','The city of Beijing277','The city of Beijing278','The city of Beijing279','The city of Beijing280','The city of Beijing281','The city of Beijing282','The city of Beijing283','The city of Beijing284','The city of Beijing285','The city of Beijing286','The city of Beijing287','The city of Beijing288','The city of Beijing289','The city of Beijing290','The city of Beijing291','The city of Beijing292','The city of Beijing293','The city of Beijing294','The city of Beijing295','The city of Beijing296','The city of Beijing297','The city of Beijing298','The city of Beijing299','The city of Beijing300','The city of Beijing301','The city of Beijing302','The city of Beijing303','The city of Beijing304','The city of Beijing305','The city of Beijing306','The city of Beijing307','The city of Beijing308','The city of Beijing309','The city of Beijing310','The city of Beijing311','The city of Beijing312','The city of Beijing313','The city of Beijing314','The city of Beijing315','The city of Beijing316','The city of Beijing317','The city of Beijing318','The city of Beijing319','The city of Beijing320','The city of Beijing321','The city of Beijing322','The city of Beijing323','The city of Beijing324','The city of Beijing325','The city of Beijing326','The city of Beijing327','The city of Beijing328','The city of Beijing329','The city of Beijing330','The city of Beijing331','The city of Beijing332','The city of Beijing333','The city of Beijing334','The city of Beijing335','The city of Beijing336','The city of Beijing337','The city of Beijing338','The city of Beijing339','The city of Beijing340','The city of Beijing341','The city of Beijing342','The city of Beijing343','The city of Beijing344','The city of Beijing345','The city of Beijing346','The city of Beijing347','The city of Beijing348','The city of Beijing349','The city of Beijing350','The city of Beijing351','The city of Beijing352','The city of Beijing353','The city of Beijing354','The city of Beijing355','The city of Beijing356','The city of Beijing357','The city of Beijing358','The city of Beijing359','The city of Beijing360','The city of Beijing361','The city of Beijing362','The city of Beijing363','The city of Beijing364','The city of Beijing365','The city of Beijing366','The city of Beijing367','The city of Beijing368','The city of Beijing369','The city of Beijing370','The city of Beijing371','The city of Beijing372','The city of Beijing373','The city of Beijing374','The city of Beijing375','The city of Beijing376','The city of Beijing377','The city of Beijing378','The city of Beijing379','The city of Beijing380','The city of Beijing381','The city of Beijing382','The city of Beijing383','The city of Beijing384','The city of Beijing385','The city of Beijing386','The city of Beijing387','The city of Beijing388','The city of Beijing389','The city of Beijing390','The city of Beijing391','The city of Beijing392','The city of Beijing393','The city of Beijing394','The city of Beijing395','The city of Beijing396','The city of Beijing397','The city of Beijing398','The city of Beijing399','The city of Beijing400','The city of Beijing401','The city of Beijing402','The city of Beijing403','The city of Beijing404','The city of Beijing405','The city of Beijing406','The city of Beijing407','The city of Beijing408','The city of Beijing409','The city of Beijing410','The city of Beijing411','The city of Beijing412','The city of Beijing413','The city of Beijing414','The city of Beijing415','The city of Beijing416','The city of Beijing417','The city of Beijing418','The city of Beijing419','The city of Beijing420','The city of Beijing421','The city of Beijing422','The city of Beijing423','The city of Beijing424','The city of Beijing425','The city of Beijing426','The city of Beijing427','The city of Beijing428','The city of Beijing429','The city of Beijing430','The city of Beijing431','The city of Beijing432','The city of Beijing433','The city of Beijing434','The city of Beijing435','The city of Beijing436','The city of Beijing437','The city of Beijing438','The city of Beijing439','The city of Beijing440','The city of Beijing441','The city of Beijing442','The city of Beijing443','The city of Beijing444','The city of Beijing445','The city of Beijing446','The city of Beijing447','The city of Beijing448','The city of Beijing449','The city of Beijing450','The city of Beijing451','The city of Beijing452','The city of Beijing453','The city of Beijing454','The city of Beijing455','The city of Beijing456','The city of Beijing457','The city of Beijing458','The city of Beijing459','The city of Beijing460','The city of Beijing461','The city of Beijing462','The city of Beijing463','The city of Beijing464','The city of Beijing465','The city of Beijing466','The city of Beijing467','The city of Beijing468','The city of Beijing469','The city of Beijing470','The city of Beijing471','The city of Beijing472','The city of Beijing473','The city of Beijing474','The city of Beijing475','The city of Beijing476','The city of Beijing477','The city of Beijing478','The city of Beijing479','The city of Beijing480','The city of Beijing481','The city of Beijing482','The city of Beijing483','The city of Beijing484','The city of Beijing485','The city of Beijing486','The city of Beijing487','The city of Beijing488','The city of Beijing489','The city of Beijing490','The city of Beijing491','The city of Beijing492','The city of Beijing493','The city of Beijing494','The city of Beijing495','The city of Beijing496','The city of Beijing497','The city of Beijing498','The city of Beijing499','The city of Beijing500','The city of Beijing501','The city of Beijing502','The city of Beijing503','The city of Beijing504','The city of Beijing505','The city of Beijing506','The city of Beijing507','The city of Beijing508','The city of Beijing509','The city of Beijing510','The city of Beijing511','The city of Beijing512','The city of Beijing513','The city of Beijing514','The city of Beijing515','The city of Beijing516','The city of Beijing517','The city of Beijing518','The city of Beijing519','The city of Beijing520','The city of Beijing521','The city of Beijing522','The city of Beijing523','The city of Beijing524','The city of Beijing525','The city of Beijing526','The city of Beijing527','The city of Beijing528','The city of Beijing529','The city of Beijing530','The city of Beijing531','The city of Beijing532','The city of Beijing533','The city of Beijing534','The city of Beijing535','The city of Beijing536','The city of Beijing537','The city of Beijing538','The city of Beijing539','The city of Beijing540','The city of Beijing541','The city of Beijing542','The city of Beijing543','The city of Beijing544','The city of Beijing545','The city of Beijing546','The city of Beijing547','The city of Beijing548','The city of Beijing549','The city of Beijing550','The city of Beijing551','The city of Beijing552','The city of Beijing553','The city of Beijing554','The city of Beijing555','The city of Beijing556','The city of Beijing557','The city of Beijing558','The city of Beijing559','The city of Beijing560','The city of Beijing561','The city of Beijing562','The city of Beijing563','The city of Beijing564','The city of Beijing565','The city of Beijing566','The city of Beijing567','The city of Beijing568','The city of Beijing569','The city of Beijing570','The city of Beijing571','The city of Beijing572','The city of Beijing573','The city of Beijing574','The city of Beijing575','The city of Beijing576','The city of Beijing577','The city of Beijing578','The city of Beijing579','The city of Beijing580','The city of Beijing581','The city of Beijing582','The city of Beijing583','The city of Beijing584','The city of Beijing585','The city of Beijing586','The city of Beijing587','The city of Beijing588','The city of Beijing589','The city of Beijing590','The city of Beijing591','The city of Beijing592','The city of Beijing593','The city of Beijing594','The city of Beijing595','The city of Beijing596','The city of Beijing597','The city of Beijing598','The city of Beijing599','The city of Beijing600','The city of Beijing601','The city of Beijing602','The city of Beijing603','The city of Beijing604','The city of Beijing605','The city of Beijing606','The city of Beijing607','The city of Beijing608','The city of Beijing609','The city of Beijing610','The city of Beijing611','The city of Beijing612','The city of Beijing613','The city of Beijing614','The city of Beijing615','The city of Beijing616','The city of Beijing617','The city of Beijing618','The city of Beijing619','The city of Beijing620','The city of Beijing621','The city of Beijing622','The city of Beijing623','The city of Beijing624','The city of Beijing625','The city of Beijing626','The city of Beijing627','The city of Beijing628','The city of Beijing629','The city of Beijing630','The city of Beijing631','The city of Beijing632','The city of Beijing633','The city of Beijing634','The city of Beijing635','The city of Beijing636','The city of Beijing637','The city of Beijing638','The city of Beijing639','The city of Beijing640','The city of Beijing641','The city of Beijing642','The city of Beijing643','The city of Beijing644','The city of Beijing645','The city of Beijing646','The city of Beijing647','The city of Beijing648','The city of Beijing649','The city of Beijing650','The city of Beijing651','The city of Beijing652','The city of Beijing653','The city of Beijing654','The city of Beijing655','The city of Beijing656','The city of Beijing657','The city of Beijing658','The city of Beijing659','The city of Beijing660','The city of Beijing661','The city of Beijing662','The city of Beijing663','The city of Beijing664','The city of Beijing665','The city of Beijing666','The city of Beijing667','The city of Beijing668','The city of Beijing669','The city of Beijing670','The city of Beijing671','The city of Beijing672'.....csdn The text editor limit10000The characters are following) NULL DEFAULT NULL ;

Posted by Grover at January 05, 2017 - 5:59 AM

What is the cause of the

Refer to the three article


http://dev.mysql.com/doc/refman/5.1/en/column-count-limit.html


First the definition table cannot span pages, similar to the sqlserver table definition must not exceed 8000
The second I defined table using the utf8 character set, so that the space occupied by the more

But it is not easy

You have what good method

Posted by Grover at January 05, 2017 - 6:38 AM

For tables.
You like enum, in fact, of little significance.

Posted by Berger at January 13, 2017 - 6:37 AM

Here is just an example, actually does have such needs, but limited to the table definition of space size, the enum enumeration value words Limited

Posted by Grover at January 13, 2017 - 7:25 AM