On Fri, Mar 25, 2005 at 07:27:47PM -0800, David Blomstrom wrote: > 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. > > [snip] > > `borderk` INT( 6, 1 ) DEFAULT NULL ,
This is your problem. INT does not take two parameters. > [ snip ] > > 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 That's why the error message says near "1) ...". Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]