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 vote115 views1 answer
Get all employee of salary if more than in sql
SQL
13 votes142 views3 answers
Mysqldump structure only
SQL
10 votes114 views2 answers
Sql merge statement
SQL
1 vote122 views1 answer
Postgresql round double precision
SQL
1 vote116 views2 answers
Mysql filter by date mount
SQL
0 vote110 views5 answers
Select concat alter table mysql
SQL
1 vote73 views1 answer
Pagination sql
SQL
1 vote116 views2 answers
Mysql order by date asc null last
SQL
21 votes91 views7 answers
Table drop if exist sql server
SQL
0 vote117 views1 answer
Resullt all update knex mysql
SQL