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

58 votes589 views4 answers
Mysql drop column
SQL
1 vote365 views1 answer
Deleting database in sql
SQL
8 votes332 views1 answer
Alter tablespace add datafile
SQL
0 vote379 views1 answer
Dual in db2
SQL
2 votes460 views1 answer
Ssh mysql port forwarding
SQL
8 votes338 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote442 views1 answer
Restart serial number for postgres
SQL
0 vote306 views2 answers
How to combine two sql queries in one result
SQL
0 vote349 views1 answer
Sql server python connection
SQL
0 vote333 views1 answer
2020 new year
SQL