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 vote290 views1 answer
Mysql join column order By and group By
SQL
15 votes289 views3 answers
Postgresql change column type
SQL
0 vote286 views1 answer
Sql tabelle erstellen
SQL
0 vote455 views1 answer
Multiple row join
SQL
-1 vote284 views5 answers
Operator in sql
SQL
3 votes290 views1 answer
Oracle function return
SQL
0 vote289 views1 answer
Sql server Cost Fifo query
SQL
0 vote292 views1 answer
Mysql zerofill
SQL
2 votes278 views1 answer
Mysql create user with mysql_native_password
SQL
1 vote268 views1 answer
Oracle case
SQL