Please support our MS SQL advertiser: Programming Forums
Views: 626 | Replies: 1
 |
•
•
Join Date: Nov 2007
Posts: 128
Reputation: 
Rep Power: 1
Solved Threads: 0
Junior Poster
I just started learning php and mySQL, if i want to create 2 tables, how do i connect them with a foreign key? In oracle, it is something like below, would any one point out what have to change to make it work in mySQL? phpMyadmin GUI doesn't seem like it needs a foreign key to connect a table. Please explain a bit and thanks very much.
create table customer( cid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, name VARCHAR(20)); CREATE TABLE order( oid INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, o_date VARCHAR(10), FOREIGN KEY(cid) REFERENCES customers);
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
