sql syntax error 1064 in workbench-generated script

Question

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.

Answer 1

Give this a try, your issue was the syntax with the foreign key and the references.

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 (`REF#`) REFERENCES `REF` (`REF#`) 
 ON DELETE CASCADE
 ON UPDATE CASCADE)
 ENGINE = InnoDB
 DEFAULT CHARACTER SET = big5

Syntax link

Another helpful link