Breaking News: Grepper is joining You.com. Read the official announcement!

insert many to many sql

Victorious Vole answered on May 31, 2020 Popularity 9/10 Helpfulness 3/10

answer insert many to many sql

insert many to many sql

Comment

INSERT INTO persons (firstname,lastname) VALUES ('John','Doe');
SET @person_id = LAST_INSERT_ID();

INSERT IGNORE INTO properties (property) VALUES ('property_A');
SET @property_id = LAST_INSERT_ID();
INSERT INTO has_property (person_id,property_id) VALUES(@person_id, @property_id);

INSERT IGNORE INTO properties (property) VALUES ('property_B');
SET @property_id = LAST_INSERT_ID();
INSERT INTO has_property (person_id,property_id) VALUES(@person_id, @property_id);

INSERT IGNORE INTO properties (property) VALUES ('property_C');
SET @property_id = LAST_INSERT_ID();
INSERT INTO has_property (person_id,property_id) VALUES(@person_id, @property_id);

Popularity 9/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: insert many-to-many sql

Link to this answer
Share Copy Link