Entering edit mode
6.4 years ago
sharmatina189059
▴
110
Deal all Can anyone tell me the problem with this command.
mysql> ALTER TABLE Biocyc_2 ADD CONSTRAINT fk_col FOREIGN KEY (User_ids) REFERENCES Unique_reaction (User_ids) on DELETE CASADE ON UPDATE RESTRICT;
It is showing this 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 'CASADE ON UPDATE RESTRICT' at line 1 mysql>