|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: 2 MySQL Errors
From: Jim Winstead (jimw
mysql.com)
Date: Fri Mar 25 2005 - 21:31:46 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]