I can't figure out why I get an error message relating
to fiels "borderstates" and "bordernotes" when I try
to create a new table. One is VARCHAR, the other TEXT,
and both are NULL, like almost every field on the
table.
Can someone tell me what I'm doing wrong? Thanks.
SQL-query:
CREATE TABLE `geog` (
`NID` INT( 3 ) NOT NULL AUTO_INCREMENT ,
`IDArea` CHAR( 3 ) NOT NULL ,
`Name` VARCHAR( 50 ) NOT NULL ,
`coordNS` VARCHAR( 7 ) DEFAULT NULL ,
`coordNS2` VARCHAR( 3 ) DEFAULT NULL ,
`coordEW` VARCHAR( 8 ) DEFAULT NULL ,
`coordEW2` VARCHAR( 3 ) DEFAULT NULL ,
`coordnotes` TEXT DEFAULT NULL ,
`location` VARCHAR( 255 ) DEFAULT NULL ,
`mapref` VARCHAR( 33 ) DEFAULT NULL ,
`areak` DECIMAL( 9, 2 ) DEFAULT NULL ,
`arealandk` DECIMAL( 9, 2 ) DEFAULT NULL ,
`areawaterk` DECIMAL( 9, 2 ) DEFAULT NULL ,
`areanotes` VARCHAR( 255 ) DEFAULT NULL ,
`aracomp` VARCHAR( 100 ) DEFAULT NULL ,
`borderk` INT( 6, 1 ) DEFAULT NULL ,
`borderstates` VARCHAR( 255 ) DEFAULT NULL ,
`bordernotes` TEXT DEFAULT NULL ,
`coastk` DECIMAL( 6.1 ) DEFAULT NULL ,
`coastnotes` TEXT DEFAULT NULL ,
`martersea` INT( 3 ) DEFAULT NULL ,
`marconzone` INT( 2 ) DEFAULT NULL ,
`marconshelf` VARCHAR( 255 ) DEFAULT NULL ,
`marexecon` INT( 3 ) DEFAULT NULL ,
`marexfish` INT( 3 ) DEFAULT NULL ,
`marnotes` VARCHAR( 255 ) DEFAULT NULL ,
`climate` VARCHAR( 255 ) DEFAULT NULL ,
`elevhighpt` VARCHAR( 255 ) DEFAULT NULL ,
`elevhighm` INT( 4 ) DEFAULT NULL ,
`elevlowpt` VARCHAR( 255 ) DEFAULT NULL ,
`elevlowm` INT( 4 ) DEFAULT NULL ,
`elevnotes` VARCHAR( 255 ) DEFAULT NULL ,
`terrain` TEXT DEFAULT NULL ,
`natres` TEXT DEFAULT NULL ,
`nathaz` TEXT DEFAULT NULL ,
`envagree` TEXT DEFAULT NULL ,
`envagree2` VARCHAR( 255 ) DEFAULT NULL ,
`envissues` TEXT DEFAULT NULL ,
`landuse` INT( 2, 2 ) DEFAULT NULL ,
`landusecrops` INT( 2, 2 ) DEFAULT NULL ,
`landuseother` INT( 2, 2 ) DEFAULT NULL ,
`landusenotes` VARCHAR( 100 ) DEFAULT NULL ,
`irrigate` INT( 6, 2 ) DEFAULT NULL ,
`irrigatenotes` VARCHAR( 255 ) DEFAULT NULL ,
`geognotes` TEXT DEFAULT NULL ,
PRIMARY KEY ( `NID` ) ,
INDEX ( `IDArea` )
)
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server
version for the right syntax to use near '1) DEFAULT
NULL, `borderstates` VARCHAR(255) DEFAULT NULL,
`bordernotes` TEXT DE' at line 1
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
