Page 1 of 1

Trying to create a table...

Posted: Sun Mar 27, 2005 5:08 am
by Perfidus

Code: Select all

CREATE TABLE IF NOT EXISTS `distancias` (`salida` VARCHAR(400) default NULL ,`ADSUBIA` INT(10) NOT NULL ,`fin` TINYINT UNSIGNED ZEROFILL not null)
What's wrong?

Posted: Sun Mar 27, 2005 7:50 am
by anjanesh
CREATE TABLE IF NOT EXISTS `distancias` (`salida` VARCHAR(255) default NULL ,`ADSUBIA` INT(10) NOT NULL ,`fin` TINYINT UNSIGNED ZEROFILL not null)
Maximum value of varchar is 255 - you specified 400.