-
How To Insert Values For Foreign Key
Hi,
I am new in mysql..........Please solution this problem.
I created the following table
CREATE TABLE User (
User_Id VARCHAR(25) PRIMARY KEY
);
and I created another table with reference of first table
CREATE TABLE User_Group (
User_Id VARCHAR(25),
Group_Id VARCHAR(25),
FOREIGN KEY(User_Id) REFERENCES User(User_Id)
);
and then How to insert the values in User_Group table.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|