SQL query:

-- ----------------------------------------------------- -- Table `yp038645_trash`.`Comments` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `yp038645_trash`.`Comments` ( `id` INT NOT NULL AUTO_INCREMENT , `Users_id` INT NOT NULL , `comment` TEXT( 500 ) NOT NULL , `date` TIMESTAMP( 12 ) NOT NULL , PRIMARY KEY ( `id` ) , INDEX `fk_Comments_Users1_idx` ( `Users_id` ASC ) , CONSTRAINT `fk_Comments_Users1` FOREIGN KEY ( `Users_id` ) REFERENCES `yp038645_trash`.`Users` ( `id` ) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB;

MySQL Answer: Documentation

 #1064 - 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 '(12) NOT NULL, PRIMARY KEY (`id`), INDEX `fk_Comments_Users1_idx` (`Users_' at line 8

    1 answer 1

    The data type TIMESTAMP does not have a length specification. Manual .

    • And the script worked on LAN ... - Ghost
    • So what? not an indicator - depending on the version and settings, some blunders can be ignored ... - Akina