Re: incorrect column specifier

2002-05-31 Thread Keith C. Ivey
On 31 May 2002, at 11:56, T. Dahms wrote: > This line -> > building_idx decimal(8,0) unsigned zerofill DEFAULT '' not > null auto_increment <-is in a supplied perl script and causes the > error message. An AUTO_INCREMENT column has to be an integer (see http://www.mysql.com/doc/C/R/CREA

Re: incorrect column specifier

2002-05-31 Thread Benjamin Pflugmann
Hi. I am not sure, but I guess that AUTO_INCREMENT is not allowed for DECIMAL. Bye, Benjamin. On Fri, May 31, 2002 at 11:56:36AM -0500, [EMAIL PROTECTED] wrote: > I'm getting an error ->incorrect column specifier > using MySQL 3.23.37 on SuSe 7.2 > This line -> &g

incorrect column specifier

2002-05-31 Thread T. Dahms
I'm getting an error ->incorrect column specifier using MySQL 3.23.37 on SuSe 7.2 This line -> building_idx decimal(8,0) unsigned zerofill DEFAULT '' not null auto_increment <-is in a supplied perl script and causes the error message. I acknowledge this is just one