Can someone tell me what I'm doing wrong? When I first
tried to create this table, I got an error message
pointing out two fields that looked perfectly fine to
me. I couldn't figure it out, so I just deleted the
fields - but it then fingered two different fields. I
deleted them, and now it says there's a problem with
two other fields.
I don't get it. Thanks.
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`' at line 17
__________________________________
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]
