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
Last activity: Jul 25, 2025, 06:00 AM