Sample Header Ad - 728x90

sql syntax error 1064 in workbench-generated script

0 votes
1 answer
543 views
I'm not very familiar with sql, so I'm using workbench to create a db. I keep getting this error: Executing 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 ') REFERENCES project2.REF () ON DELETE CASCADE ON UPDATE CASCADE' at line 6 SQL Code: CREATE TABLE IF NOT EXISTS project2.REF_AUTH ( REF# INT(11) NOT NULL AUTO_INCREMENT, RAUTHOR VARCHAR(45) NOT NULL, PRIMARY KEY (REF#, RAUTHOR), CONSTRAINT REF# FOREIGN KEY () REFERENCES project2.REF () ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB DEFAULT CHARACTER SET = big5 SQL script execution finished: statements: 4 succeeded, 1 failed Any help would be greatly appreciated.
Asked by so8857 (101 rep)
Apr 7, 2018, 05:02 PM
Last activity: Jul 25, 2025, 06:00 AM