Error Creating table in MySql Administrator
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)
Subject
Written By
Posted
Error Creating table in MySql Administrator
November 05, 2009 10:16AM
November 05, 2009 11:09AM
November 05, 2009 02:49PM
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.