日期:2014-05-16  浏览次数:20727 次

mysql MERGE 错误(differently defined or of non-MyISAM type)
错误代码:
Error Code : 1168
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist

出现这样的错误原因是:
表结构不一样或者表字段没有包含varchar类型。
如:
CREATE TABLE `website0001` (                                                                                      
                 `id` int(11) NOT NULL AUTO_INCREMENT,                                                                                              
                 `siteBigType` int(11) DEFAULT NULL,                                                                                                                                                             
                 `siteSmallType` int(11) DEFAULT NULL,                                                                                                                                   
                 `siteWorth` varchar(15) DEFAULT '0' COMMENT '网站价值',                                                                             
                 `date` date DEFAULT NULL,                                                                                                            
                 PRIMARY KEY (`id`)                                                                                                                                                                           
               )ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC  


CREATE TABLE `website0001` (                                                                                      
                 `id` int(11) NOT NULL AUTO_INCREMENT,                                                                                              
                 `siteBigType` int(11) DEFAULT NULL,                                                                                                                                                             
                 `siteSmallType` int(11) DEFAULT NULL,                                                                                                                                   
                 `siteWorth` varchar(15) DEFAULT '0' COMMENT '网站价值',                                                                             
                 `date` date DEFAULT NULL,                                                                                                            
                 PRIMARY KEY (`id`)                                                                                                                                                                           
               )ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC  

CREATE TABLE `allwebsite` (                                                                                                       
                `id` int(11) NOT NULL AUTO_INCREMENT,                                                                                              
                 `siteBigType` int(11) DEFAULT NULL,                                                                                                                                                             
                 `siteSmallType` int(11) DEFAULT NULL,                                                                                                                                            
                 `siteWorth` varchar(15) DEFAULT '0' COMMENT '网站价值',                                                                             
                 `date` date DEFAULT NULL,                                                                                                             
		index(`id`)