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

1 vote115 views1 answer
Create sqlite database in laravel
SQL
7 votes104 views1 answer
Set sequence value oracle
SQL
0 vote106 views1 answer
Data types mysql vs postgresql
SQL
0 vote108 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote113 views1 answer
Mysql update from select on same table
SQL
0 vote115 views1 answer
Mysql remove last character
SQL
0 vote104 views1 answer
Psql store procedure-return multiple table values
SQL
2 votes118 views1 answer
Removing view
SQL
0 vote91 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
2 votes112 views1 answer
Pdo mysql insert
SQL