MySQL Forums
Forum List  »  MySQL Administrator

Error Creating table in MySql Administrator
Posted by: Brandon Larkin
Date: November 05, 2009 10:16AM

I am getting an error when I try to create a table in MySql Administrator. The error and the generated SQL command are below, if anyone could point me in the right direction, that would be great.

CREATE TABLE `434_larkin04`.`guestbook` (
`id` INT AUTO_INCREMENT,
`fullname` VARCHAR,
`email` VARCHAR,
`website` VARCHAR,
`words` TEXT,
PRIMARY KEY (`id`)
)
ENGINE = InnoDB
CHARACTER SET utf8
COMMENT = 'Guestbook DB for Assignment 7-1';



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 '
`email` VARCHAR,
`website` VARCHAR,
`words` TEXT,
PRIMARY KEY (`id`)
)
' at line 3 (error 1064)

Options: ReplyQuote


Subject
Written By
Posted
Error Creating table in MySql Administrator
November 05, 2009 10:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.