Uma Bankuru Uma Bankuru - 1 month ago 19
MySQL Question

Mysql workbench Error while applying SQL script to the database

Operation failed: There was an error while applying the SQL script to the database.


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 ')
REFERENCES
ad_d19fb99c240e6c8
.
user
()
ON DELETE NO ACTION
ON U' at line 10


SQL Statement:

CREATE TABLE `ad_d19fb99c240e6c8`.`instructor_profile` (
`InstructorId` INT NULL,
`InstructorName` VARCHAR(45) NULL,
`companyId` INT NULL,
`companyName` VARCHAR(45) NULL,
`instructorEmail` VARCHAR(45) NULL,
`ManagerName` VARCHAR(45) NULL,
`ManagerEmail` VARCHAR(45) NULL,
CONSTRAINT `UserId`
FOREIGN KEY ()
REFERENCES `ad_d19fb99c240e6c8`.`user` ()
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `VendorId`
FOREIGN KEY ()
REFERENCES `ad_d19fb99c240e6c8`.`vendor` ()
ON DELETE NO ACTION
ON UPDATE NO ACTION)

Answer

You must put a column name inside the parentheses, as others have said. This must match one of the column names previously given in your CREATE TABLE statement.

Comments