From: Darryle Steplight (dsteplightgmail.com)
Date: Fri Feb 20 2009 - 01:03:50 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Jeff,
     For starters, it looks like you need a value for VARCHAR. Try the
same statement but with VARCHAR(255) .

On Fri, Feb 20, 2009 at 1:17 AM, Jeff Murdock <jeff_murdockyahoo.com> wrote:
> This is on a Mac OS X (v10.5.6) system in case that matters.
>
>
>
> 1. - MySQL Administrator Help button says:
>
> HELP
>
> Help isn't available for MySQL Administrator.
>
>
> Really, no help or did I screw-up the install somehow?
>
>
>
> 2. - I tried to create my first Table in MySQL Administrator but got this
> message:
>
> ERROR
>
> Error executing SQL commands to create table.
> 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 'DEFAULT NULL,
> `LastName` VARCHAR DEFAULT NULL,
> `Street1` VARCHAR DEFAULT NUL' at line 3 (error 1064)
>
>
> Trying to Execute this:
>
>
> CREATE TABLE `test`.`AddressBook` (
> `RecNo` INT NOT NULL AUTO_INCREMENT,
> `FirstName` VARCHAR DEFAULT NULL,
> `LastName` VARCHAR DEFAULT NULL,
> `Street1` VARCHAR DEFAULT NULL,
> `Street2` VARCHAR DEFAULT NULL,
> `City` VARCHAR DEFAULT NULL,
> `State` VARCHAR DEFAULT NULL,
> `Zip` VARCHAR DEFAULT NULL,
> `HomePhone` VARCHAR DEFAULT NULL,
> `CellPhone` VARCHAR DEFAULT NULL,
> PRIMARY KEY (`RecNo`)
> )
> CHARACTER SET utf8
> COMMENT = 'Sample';
>
>
>
>
>
>
>
> Jeff
>
>
>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]