MySQL syntax error on adding foreign key constraint

Question

I have two tables that look like the following:

I am then trying to add a foreign key constraint like so:

mysql> ALTER TABLE `Order`
    -> ADD CONSTRAINT `FK_baseline_order`
    ->     FOREIGN KEY `baselineId`
    ->     REFERENCES `Baseline` (`id`)
    ->     ON UPDATE CASCADE ON DELETE CASCADE;

I get the following "syntax" error:

ERROR 1064 (42000): 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 Baseline (id) ON UPDATE CASCADE ON DELETE CASCADE' at line 4

I for the life of me can't figure out what I'm doing wrong. I feel like I'm missing something really obvious here...

Deleted my answer, I misread the error

helion3
– helion3

2014-02-06 22:02:19 +00:00
Commented Feb 6, 2014 at 22:02 — helion3
– helion3, Commented Feb 6, 2014 at 22:02

user330315 · Accepted Answer · 2014-02-06 21:59:41Z

3

You need to put the referencing columns between parenthesis as well:

ALTER TABLE `Order`
   ADD CONSTRAINT `FK_baseline_order`
      FOREIGN KEY (`baselineId`)     <<<<-- here
      REFERENCES `Baseline` (`id`)
      ON UPDATE CASCADE ON DELETE CASCADE;

answered Feb 6, 2014 at 21:59

user330315

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

Comments

Rahul · Accepted Answer · 2014-02-06 22:03:48Z

0

Try putting your foriegn key column inside parenthesis like

ALTER TABLE `Order`
 ADD CONSTRAINT `FK_baseline_order`
     FOREIGN KEY (`baselineId`) <-- Here
    REFERENCES `Baseline` (`id`)
     ON UPDATE CASCADE ON DELETE CASCADE;

answered Feb 6, 2014 at 22:03

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Collectives™ on Stack Overflow

MySQL syntax error on adding foreign key constraint

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related