MySQL: Error 1628: Comment for table 'customer' is too long (max = 60)

Question

After fixing Error 1253 (http://stackoverflow.com/questions/3567808/mysql-unable-to-fulling-forward-engineering-sakila-sample-into-server), I have Error 1628.

Executing SQL script in server

ERROR: Error 1628: Comment for table 'customer' is too long (max = 60)

Scripts:

CREATE TABLE IF NOT EXISTS sakila.customer (

customer_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT ,

store_id TINYINT(3) UNSIGNED NOT NULL ,

first_name VARCHAR(45) NOT NULL ,

last_name VARCHAR(45) NOT NULL ,

email VARCHAR(50) NULL DEFAULT NULL ,

address_id SMALLINT(5) UNSIGNED NOT NULL ,

active TINYINT(1) NOT NULL DEFAULT TRUE ,

create_date DATETIME NOT NULL ,

last_update TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ,

PRIMARY KEY (customer_id) ,

INDEX idx_fk_store_id (store_id ASC) ,

INDEX idx_fk_address_id (address_id ASC) ,

INDEX idx_last_name (last_name ASC) ,

CONSTRAINT fk_customer_address

FOREIGN KEY (`address_id` )

REFERENCES `sakila`.`address` (`address_id` )

ON DELETE RESTRICT

ON UPDATE CASCADE,

CONSTRAINT fk_customer_store

FOREIGN KEY (`store_id` )

REFERENCES `sakila`.`store` (`store_id` )

ON DELETE RESTRICT

ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = utf8

COMMENT = 'Table storing all customers. Holds foreign keys to the address table and the store table where this customer is registered.\n\nBasic information about the customer like first and last name are stored in the table itself. Same for the date the record was created and when the information was last updated.'

SQL script execution finished: statements: 3 succeeded, 1 failed

Answer 1

As stated in the MySQL docs, a comment is limited to 255 characters: http://dev.mysql.com/doc/refman/5.1/en/create-table.html#id3411882. Your comment is 305 characters, and it would seem, from the error message, that your particular MySQL install has a 60 character limit.