Jump to content

mysql statement explained


mindapolis

Recommended Posts

I just want to make sure I'm understanding the following code correctly.  The primary key, order_number, from the orders table is now the foreign key in the customers table, correct? 

 

 

ALTER TABLE `customers` ADD FOREIGN KEY ( `customers_id` ) REFERENCES `auntievics`.`orders` (
`order_number`
);

Link to comment
https://forums.phpfreaks.com/topic/255896-mysql-statement-explained/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.