Re: Newbie Question - MySQL Administrator

2009-02-20 Thread Walter Heck 
The online help for mysql administrator is here:
http://dev.mysql.com/doc/administrator/en/index.html

OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com



On Fri, Feb 20, 2009 at 7:17 AM, Jeff Murdock jeff_murd...@yahoo.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
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Newbie Question - MySQL Administrator

2009-02-19 Thread Jeff Murdock 

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

Re: Newbie Question - MySQL Administrator

2009-02-19 Thread Darryle Steplight 
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_murd...@yahoo.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
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org