Re: Error Creating table in MySql Administrator

[Chad Bourque]

Brandon,

The varchar datatype requires a width:

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

`
The error tells you where to look (near '`email`...). The problem is always right before where the error says it is near.

HTH,
Chad