· 9 years ago · Dec 08, 2016, 09:46 PM
1Executing SQL script in server ERROR: Error 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 '), `authorName` VARCHAR(45) NULL, `authorDesc` BLOB NULL, PRIMARY KEY (`au' at line 5 SQL Code:
2 -- -----------------------------------------------------
3 -- Table `mydb`.`authors`
4 -- -----------------------------------------------------
5 CREATE TABLE IF NOT EXISTS `mydb`.`authors` (
6 `authorID` INT GENERATED ALWAYS AS (),
7 `authorName` VARCHAR(45) NULL,
8 `authorDesc` BLOB NULL,
9 PRIMARY KEY (`authorID`))
10 ENGINE = InnoDB
11
12SQL script execution finished: statements: 6 succeeded, 1 failed
13
14Fetching back view definitions in final form. Nothing to fetch