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

0 vote124 views1 answer
Show all mongodb
SQL
1 vote113 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote140 views1 answer
Example of sql querry result sepapreted by comma
SQL
-2 votes133 views3 answers
How to fetch first 10 rows in sql
SQL
1 vote114 views1 answer
Create new table in SQL from old table with data
SQL
0 vote113 views2 answers
Sql join on comma separated field
SQL
0 vote113 views1 answer
Console output pl sql
SQL
0 vote112 views1 answer
Select from 3 tables one is empty
SQL
0 vote113 views1 answer
Mysql case when null
SQL
0 vote116 views1 answer
Move table to a different schema
SQL