I currently have two tables: tblCustomer and tblOrders.
In tblCustomer I have a field CustomerID that was set with the SERIAL datatype and set as PRIMARY. In tblOrders I have the fields OrderID that was set with the SERIAL datatype and set as PRIMARY. I also have a field called CustomerID with the BIGINT(20) datatype. I am trying to create a foreign key on tblOrders.Custo merID to relate back to tblCustomer.Cus tomerID. All the data is InnoDB.
I get an error of check datatypes. I'm not sure what I am doing wrong. Any Ideas?
In tblCustomer I have a field CustomerID that was set with the SERIAL datatype and set as PRIMARY. In tblOrders I have the fields OrderID that was set with the SERIAL datatype and set as PRIMARY. I also have a field called CustomerID with the BIGINT(20) datatype. I am trying to create a foreign key on tblOrders.Custo merID to relate back to tblCustomer.Cus tomerID. All the data is InnoDB.
Code:
ALTER TABLE `tblOrders` ADD FOREIGN KEY ( `CustomerID` ) REFERENCES `Sample`.`tblCustomer` ( `CustomerID` ) ON DELETE CASCADE ON UPDATE CASCADE ;
Comment