Please ignore this thread. I think my main problem is
I need glasses!
--- David Blomstrom <[EMAIL PROTECTED]> wrote:
> 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]
>
>
__________________________________
Do you Yahoo!?
Make Yahoo! your home page
http://www.yahoo.com/r/hs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
