Re: Problem creating database and tables from script

[Jose Cobo Garcia]

Hi,

the script looks like:

CREATE SCHEMA IF NOT EXISTS `assets` DEFAULT CHARACTER SET utf8 ;
USE `assets` ;

-- -----------------------------------------------------
-- Table `assets`.`tipus_actius`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `assets`.`tipus_actius` ;

CREATE TABLE IF NOT EXISTS `assets`.`tipus_actius` (
`idtipus_actius` INT NOT NULL AUTO_INCREMENT COMMENT '',
`nom` VARCHAR(45) NOT NULL COMMENT '',
PRIMARY KEY (`idtipus_actius`) COMMENT '')
ENGINE = InnoDB;


And the error message looks like:
Error SQL: 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 'COMMENT '')

I don't understant why is not working