Re: Creating a huge (>1000 rows) innoDB table gives me 1005 - errno: 139

Most database designs do not function well with that many columns, even if it is possible. Here is a small chunk of your column definitions: `ACCHG` double(18,4) default '0.', `ACCHG_DC` int(2) default '0', `ACCLI` double(18,4) default '0.', `ACCLI_DC` int(2) default '0', `ACCO` doubl

Creating a huge (>1000 rows) innoDB table gives me 1005 - errno: 139

Hi, I'm trying to create a table that has > 1000 columns, but I keep on getting Error Code : 1005 (errno: 139). Does anyone has an idea why this happens? I thought the limit in number of columns was around 3500... Many thanks, Filip I've attached my sql statement as a zipped file as otherwise m