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 vote155 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote141 views1 answer
Mysql function variable
SQL
0 vote145 views1 answer
Write sql query to show the details start from digit
SQL
2 votes145 views1 answer
Cast string to datetime mysql
SQL
0 vote153 views1 answer
Mysql order by rand limit 1 really slow
SQL
6 votes145 views2 answers
Mysql get yesterday
SQL
-1 vote200 views4 answers
Full outer join in sql
SQL
0 vote143 views1 answer
Data directory postgresql
SQL
0 vote187 views3 answers
Classement rang mysql 7
SQL
0 vote143 views1 answer
FIND most frequent word in sql server
SQL