Mysql workbench Error while applying SQL script to the database

Question

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)

To anyone finding this on Google: make sure your table engine matches, was an issue for this error in my case; see (and maybe upvote) here mysql Foreign key constraint is incorrectly formed error — ᴍᴇʜᴏᴠ
– ᴍᴇʜᴏᴠ, Commented Mar 6, 2021 at 19:55
@aexl Thank you, that was my issue, table engines weren't the same. — Uriahs Victor
– Uriahs Victor, Commented Apr 15, 2021 at 17:17

Code-Apprentice · Accepted Answer · 2016-10-13 12:55:59Z

2

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.

answered Oct 13, 2016 at 12:55

Code-Apprentice

84k26 gold badges162 silver badges289 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sagi · Accepted Answer · 2016-10-13 12:19:27Z

2

You're missing the column you want to reference and the column of the FK :

 CONSTRAINT `UserId`
      FOREIGN KEY (<TheColumn>)
      REFERENCES `ad_d19fb99c240e6c8`.`user` (<TheColumnInTheOtherTable>)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION,
 CONSTRAINT `VendorId`
      FOREIGN KEY (<TheSecondColumn>)
      REFERENCES `ad_d19fb99c240e6c8`.`vendor` (<TheSecondColumnInTheOtherTable>)
      ON DELETE NO ACTION
      ON UPDATE NO ACTION)

answered Oct 13, 2016 at 12:19

sagi

40.6k7 gold badges66 silver badges87 bronze badges

Comments

Shark4109 · Accepted Answer · 2016-10-13 12:19:57Z

2

You need to write name of the foreign key in parenthesis, yours are currently empty.

answered Oct 13, 2016 at 12:19

Shark4109

815 bronze badges

Comments

Pointi · Accepted Answer · 2016-10-13 12:20:44Z

1

You haven´t set the columns on which you want to set the foreign keys!

 CONSTRAINT `UserId`
    FOREIGN KEY ( `#KEYCOLUMN#` )
    REFERENCES `ad_d19fb99c240e6c8`.`user` ( `#KEYCOLUMN#` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `VendorId`
    FOREIGN KEY ( `#KEYCOLUMN#` )
    REFERENCES `ad_d19fb99c240e6c8`.`vendor` ( `#KEYCOLUMN#` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)

answered Oct 13, 2016 at 12:20

Pointi

4064 silver badges9 bronze badges

1 Comment

learning developer Over a year ago

even after adding foreign key, Im getting the error

Pathik Vejani · Accepted Answer · 2016-10-13 13:49:34Z

1

The 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 ''UserId') REFERENCES ad_d19fb99c240e6c8.user () ON DELETE NO ACTION ' at line 10 SQL Statement: CREATE TABLE ad_d19fb99c240e6c8.instructor_profile ( InstructorId INT NOT NULL, InstructorName VARCHAR(45) NULL, companyId INT NULL,
companyName VARCHAR(45) NULL, ManagerName VARCHAR(45) NULL,
ManagerEmail VARCHAR(45) NULL, InstructorEmail VARCHAR(45) NULL, CONSTRAINT UserId FOREIGN KEY ('UserId') REFERENCES ad_d19fb99c240e6c8.user () ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT VendorId FOREIGN KEY ('VendorId') REFERENCES ad_d19fb99c240e6c8.vendor () ON DELETE NO ACTION ON UPDATE NO ACTION)

still the error exists

edited Oct 13, 2016 at 13:49

Pathik Vejani

4,49711 gold badges66 silver badges110 bronze badges

answered Oct 13, 2016 at 12:36

learning developer

4212 gold badges6 silver badges11 bronze badges

1 Comment

Code-Apprentice Over a year ago

This area is for answers to your question. Please edit your question instead of posting here.

Mehdi · Accepted Answer · 2023-01-05 16:52:09Z

0

Because your new user doesn't have Privileges in MySQL Workbranch under User and Privileges tab Administrative Roles and Privileges give access to user

answered Jan 5, 2023 at 16:52

Mehdi

132 bronze badges

Collectives™ on Stack Overflow

Mysql workbench Error while applying SQL script to the database

6 Answers 6

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related