Insert many to many sql

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);

Source: stackoverflow.com

Similar codes

3 votes204 views1 answer
Oracle apex call duration
SQL
1 vote277 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote214 views1 answer
List all permissions on a table in postgres
SQL
0 vote210 views1 answer
Sql declare variable single line
SQL
2 votes205 views1 answer
Date conversion in mysql column
SQL
2 votes205 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
8 votes190 views1 answer
Oracle add month
SQL
0 vote216 views2 answers
Add new column after in sql
SQL
0 vote204 views1 answer
Convert .mdf to .bak
SQL
1 vote202 views1 answer
Oracle case
SQL