我设计的mysql数据库表中有82个字段(由于没经验,建表时设计字段数过多),建表语句如下
CREATE TABLE `customer` (
`custid` char(12) NOT NULL,
`custname` char(62) default NULL,
`custflag` char(1) default NULL,
`custLev` char(10) default NULL,
`idtype` char(1) default NULL,
`idno` char(20) default NULL,
`zhiyeno` char(20) default NULL,
`signdate` char(8) default NULL,
`signoffdate` char(8) default NULL,
`topcustid` char(10) default NULL,
`svcbitmap` text,
`custstascode` char(1) default NULL,
`province` char(2) default NULL,
`city` char(2) default NULL,
`county` char(10) default NULL,
`institution` char(62) default NULL,
`directorLaw` char(1) default NULL,
`Specialty` char(1) default NULL,
`Language` char(1) default NULL,
`Synopsis` text,
`resume` text,
`homepage` char(200) default NULL,
`Commend` char(20) default NULL,
`linkman` char(20) default NULL,
`contaddr` char(62) default NULL,
`zipcode` char(6) default NULL,
`officetel` char(20) default NULL,
`faxes` char(20) default NULL,
`emailaddr` char(42) default NULL,
`contactdept` char(80) default NULL,
`deductratio` double(5,3) NOT NULL default '1.000',
`recseq` int(11) default NULL,
`syscheck` char(1) default NULL,
`tradeid` char(2) default NULL,
`accumulateId` char(1) default NULL,
`TotalAccumBal` int(11) default NULL,
`reinfAccumBal` int(11) default NULL,
`articleAccumBal` int(11) default NULL,
`commendID` int(11) NOT NULL default '-1',
`imgfile` char(200) NOT NULL default '',
`IPaddr` char(20) default NULL,
`modelID` int(11) NOT NULL default '-1',
`WebPage` char(200) NOT NULL,
`ctype` char(10) default NULL,
`hangye` char(1) default '0',
`sellgoods` char(100) default NULL,
`buygoods` char(100) default NULL,
`zhiyeflag` char(1) default NULL,
`manamode` char(30) default NULL,
`capital` char(20) default NULL,
`location` char(30) default NULL,
`manalocation` char(30) default NULL,
`service` text,
`intro` text,
`post` char(30) default NULL,
`telphone` char(40) default NULL,
`faxnumber` char(40) default NULL,
`mobilphone` char(30) default NULL,
`foundtime` char(30) default NULL,
`comtype` varchar(11) default NULL,
`profession` char(10) default NULL,
`englishname` char(200) default NULL,
`functionary` char(30) default NULL,
`bank` char(20) default NULL,
`account` char(50) default NULL,
`area` char(20) default NULL,
`personnumber` char(20) default NULL,
`developnumber` char(20) default NULL,
`bandname` char(50) default NULL,
`monthout` char(50) default NULL,
`yearincome` char(40) default NULL,
`yearimport` char(40) default NULL,
`yearexport` char(50) default NULL,
`msauthen` char(70) default NULL,
`msauthens` char(50) default NULL,
`quantitycontrol` char(50) default NULL,
`mainet` char(40) default NULL,
`mainets` char(50) default NULL,
`keycustomer` char(50) default NULL,
`oem` char(1) default NULL,
PRIMARY KEY (`custid`),
KEY `profession` (`profession`),
KEY `ctype` (`ctype`),
KEY `province` (`province`),
KEY `city` (`city`),
CONSTRAINT `customer_ibfk_1` FOREIGN KEY (`ctype`) REFERENCES `zd_companykind` (`comkind`),
CONSTRAINT `profession` FOREIGN KEY (`profession`) REFERENCES `zd_professiontype` (`professionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
我现在当向该数据库中插入的数据过大时就会报错:报错内容如下:Got error 139 from storage engine,数据也插不进数据库,但是我现在程序都做好了,有没有能够在不影响目前程序的情况下解决上述问题。
CREATE TABLE `customer` (
`custid` char(12) NOT NULL,
`custname` char(62) default NULL,
`custflag` char(1) default NULL,
`custLev` char(10) default NULL,
`idtype` char(1) default NULL,
`idno` char(20) default NULL,
`zhiyeno` char(20) default NULL,
`signdate` char(8) default NULL,
`signoffdate` char(8) default NULL,
`topcustid` char(10) default NULL,
`svcbitmap` text,
`custstascode` char(1) default NULL,
`province` char(2) default NULL,
`city` char(2) default NULL,
`county` char(10) default NULL,
`institution` char(62) default NULL,
`directorLaw` char(1) default NULL,
`Specialty` char(1) default NULL,
`Language` char(1) default NULL,
`Synopsis` text,
`resume` text,
`homepage` char(200) default NULL,
`Commend` char(20) default NULL,
`linkman` char(20) default NULL,
`contaddr` char(62) default NULL,
`zipcode` char(6) default NULL,
`officetel` char(20) default NULL,
`faxes` char(20) default NULL,
`emailaddr` char(42) default NULL,
`contactdept` char(80) default NULL,
`deductratio` double(5,3) NOT NULL default '1.000',
`recseq` int(11) default NULL,
`syscheck` char(1) default NULL,
`tradeid` char(2) default NULL,
`accumulateId` char(1) default NULL,
`TotalAccumBal` int(11) default NULL,
`reinfAccumBal` int(11) default NULL,
`articleAccumBal` int(11) default NULL,
`commendID` int(11) NOT NULL default '-1',
`imgfile` char(200) NOT NULL default '',
`IPaddr` char(20) default NULL,
`modelID` int(11) NOT NULL default '-1',
`WebPage` char(200) NOT NULL,
`ctype` char(10) default NULL,
`hangye` char(1) default '0',
`sellgoods` char(100) default NULL,
`buygoods` char(100) default NULL,
`zhiyeflag` char(1) default NULL,
`manamode` char(30) default NULL,
`capital` char(20) default NULL,
`location` char(30) default NULL,
`manalocation` char(30) default NULL,
`service` text,
`intro` text,
`post` char(30) default NULL,
`telphone` char(40) default NULL,
`faxnumber` char(40) default NULL,
`mobilphone` char(30) default NULL,
`foundtime` char(30) default NULL,
`comtype` varchar(11) default NULL,
`profession` char(10) default NULL,
`englishname` char(200) default NULL,
`functionary` char(30) default NULL,
`bank` char(20) default NULL,
`account` char(50) default NULL,
`area` char(20) default NULL,
`personnumber` char(20) default NULL,
`developnumber` char(20) default NULL,
`bandname` char(50) default NULL,
`monthout` char(50) default NULL,
`yearincome` char(40) default NULL,
`yearimport` char(40) default NULL,
`yearexport` char(50) default NULL,
`msauthen` char(70) default NULL,
`msauthens` char(50) default NULL,
`quantitycontrol` char(50) default NULL,
`mainet` char(40) default NULL,
`mainets` char(50) default NULL,
`keycustomer` char(50) default NULL,
`oem` char(1) default NULL,
PRIMARY KEY (`custid`),
KEY `profession` (`profession`),
KEY `ctype` (`ctype`),
KEY `province` (`province`),
KEY `city` (`city`),
CONSTRAINT `customer_ibfk_1` FOREIGN KEY (`ctype`) REFERENCES `zd_companykind` (`comkind`),
CONSTRAINT `profession` FOREIGN KEY (`profession`) REFERENCES `zd_professiontype` (`professionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
我现在当向该数据库中插入的数据过大时就会报错:报错内容如下:Got error 139 from storage engine,数据也插不进数据库,但是我现在程序都做好了,有没有能够在不影响目前程序的情况下解决上述问题。
参考:http://topic.csdn.net/u/20081123/02/71983b22-6555-46c8-8aee-0c5ba304bd31.html救急方法:
把Innodb换成MyISAM