日本综合一区二区|亚洲中文天堂综合|日韩欧美自拍一区|男女精品天堂一区|欧美自拍第6页亚洲成人精品一区|亚洲黄色天堂一区二区成人|超碰91偷拍第一页|日韩av夜夜嗨中文字幕|久久蜜综合视频官网|精美人妻一区二区三区

RELATEED CONSULTING
相關(guān)咨詢
選擇下列產(chǎn)品馬上在線溝通
服務(wù)時(shí)間：8:30-17:00
你可能遇到了下面的問(wèn)題
關(guān)閉右側(cè)工具欄

新聞中心

這里有您想知道的互聯(lián)網(wǎng)營(yíng)銷解決方案
修改mysql字段順序的方法

如果需要修改mysql字段的順序，應(yīng)該怎么做呢？下面就將為您介紹修改mysql字段順序的方法，原表結(jié)構(gòu)如下：

 
 
 
    
  
  
  
  1. CREATE TABLE `tb_area_collect_school_week` (                         
    2. 
  
  
  
  2.                                `id` char(36) NOT NULL,                                            
    3. 
  
  
  
  3.                                `date_entered` varchar(20) NOT NULL,                               
    4. 
  
  
  
  4.                                `date_modified` datetime NOT NULL,                                 
    5. 
  
  
  
  5.                                `assigned_user_id` char(36) default NULL,                          
    6. 
  
  
  
  6.                                `modified_user_id` char(36) default NULL,                          
    7. 
  
  
  
  7.                                `created_by` char(36) default NULL,                                
    8. 
  
  
  
  8.                                `name` varchar(50) NOT NULL,                                       
    9. 
  
  
  
  9.                                `description` mediumtext,                                          
    10. 
  
  
  
  10.                                `deleted` tinyint(1) NOT NULL default '0',                         
    11. 
  
  
  
  11.                                `qy_id` int(10) unsigned NOT NULL auto_increment COMMENT '序號(hào)',   
    12. 
  
  
  
  12.                                `provinces` varchar(50) default NULL COMMENT '省份',               
    13. 
  
  
  
  13.                                `city` varchar(50) NOT NULL COMMENT '地市',                                                       
    14. 
  
  
  
  14.                                `school_open_up` int(20) NOT NULL COMMENT '開通學(xué)校數(shù)',            
    15. 
  
  
  
  15.                                `school_cover_percent` varchar(50) NOT NULL COMMENT '覆蓋率',      
    16. 
  
  
  
  16.                                `school_count` int(20) NOT NULL COMMENT '學(xué)?？倲?shù)',   
    17. 
  
  
  
  17.                                `area` varchar(50) default NULL,                 
    18. 
  
  
  
  18.                                `date` varchar(10) NOT NULL COMMENT '日期',                        
    19. 
  
  
  
  19.                                `system` varchar(10) default NULL COMMENT '系統(tǒng)',                  
    20. 
  
  
  
  20.                                PRIMARY KEY USING BTREE (`id`,`qy_id`),                           
    21. 
  
  
  
  21.                                KEY `provinces` USING BTREE (`provinces`),                         
    22. 
  
  
  
  22.                                KEY `city` USING BTREE (`city`),                                   
    23. 
  
  
  
  23.                                KEY `area` USING BTREE (`area`),                                   
    24. 
  
  
  
  24.                                KEY `date` USING BTREE (`date`),                                   
    25. 
  
  
  
  25.                                KEY `SYSTEM` (`system`)                                            
    26. 
  
  
  
  26.                              ) ENGINE=MyISAM DEFAULT CHARSET=gbk  
    27.

原來(lái)表結(jié)構(gòu)是這樣，現(xiàn)在要表結(jié)構(gòu)變成

 
 
 
    
  
  
  
  1. CREATE TABLE `tb_area_collect_school_week` (                          
    2. 
  
  
  
  2.                                `id` char(36) NOT NULL,                                             
    3. 
  
  
  
  3.                                `date_entered` varchar(20) NOT NULL,                                
    4. 
  
  
  
  4.                                `date_modified` datetime NOT NULL,                                  
    5. 
  
  
  
  5.                                `assigned_user_id` char(36) default NULL,                           
    6. 
  
  
  
  6.                                `modified_user_id` char(36) default NULL,                           
    7. 
  
  
  
  7.                                `created_by` char(36) default NULL,                                 
    8. 
  
  
  
  8.                                `name` varchar(50) NOT NULL,                                        
    9. 
  
  
  
  9.                                `description` mediumtext,                                           
    10. 
  
  
  
  10.                                `deleted` tinyint(1) NOT NULL default '0',                          
    11. 
  
  
  
  11.                                `qy_id` int(10) unsigned NOT NULL auto_increment COMMENT '序號(hào)',   
    12. 
  
  
  
  12.                                `provinces` varchar(50) default NULL COMMENT '省份',                
    13. 
  
  
  
  13.                                `city` varchar(50) NOT NULL COMMENT '地市',                         
    14. 
  
  
  
  14.                                `area` varchar(50) default NULL,                                    
    15. 
  
  
  
  15.                                `school_open_up` int(20) NOT NULL COMMENT '開通學(xué)校數(shù)',             
    16. 
  
  
  
  16.                                `school_cover_percent` varchar(50) NOT NULL COMMENT '覆蓋率',       
    17. 
  
  
  
  17.                                `school_count` int(20) NOT NULL COMMENT '學(xué)校總數(shù)',                 
    18. 
  
  
  
  18.                                `date` varchar(10) NOT NULL COMMENT '日期',                         
    19. 
  
  
  
  19.                                `system` varchar(10) default NULL COMMENT '系統(tǒng)',                   
    20. 
  
  
  
  20.                                PRIMARY KEY USING BTREE (`id`,`qy_id`),                            
    21. 
  
  
  
  21.                                KEY `provinces` USING BTREE (`provinces`),                          
    22. 
  
  
  
  22.                                KEY `city` USING BTREE (`city`),                                    
    23. 
  
  
  
  23.                                KEY `area` USING BTREE (`area`),                                    
    24. 
  
  
  
  24.                                KEY `date` USING BTREE (`date`),                                    
    25. 
  
  
  
  25.                                KEY `SYSTEM` (`system`)                                             
    26. 
  
  
  
  26.                              ) ENGINE=MyISAM DEFAULT CHARSET=gbk   
    27. 
  
  
  
  27.  
    28.

修改mysql字段順序的方法：

 
 
 
    
  
  
  
  1. ALTER TABLE `tb_area_collect_school_week` CHANGE `area` `area` VARCHAR(50) AFTER `city` ;  
    2.

【編輯推薦】

mysql添加刪除主鍵的方法

MySQL修改密碼的六種方法

linux下的常用mysql命令

九種常用mysql命令

MySQL自增字段的常用語(yǔ)句


網(wǎng)站欄目：修改mysql字段順序的方法
瀏覽路徑：http://www.dlmjj.cn/article/dhchced.html