Trying to create a table...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Perfidus
Forum Contributor
Posts: 114
Joined: Sun Nov 02, 2003 9:54 pm

Trying to create a table...

Post 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?
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post 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.
Post Reply