2023/03/27 2:49
If you have 2 tables in mysql. One table for group and another table for contacts. The 2 tables have many relationships. What is the | vay to link the two table then storing data?
CREATE TABLE group_contacts (
group_id INT NOT NULL,
contact_id INT NOT NULL,
PRIMARY KEY (group_id, contact_id),
FOREIGN KEY (group_id) REFERENCES groups (id),
FOREIGN KEY (contact_id) REFERENCES groups (id),
);