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 vote81 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
1 vote124 views3 answers
Execute sp in sql server
SQL
0 vote236 views1 answer
Why do we need data structure in sql
SQL
5 votes133 views1 answer
Sql table columns
SQL
0 vote131 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
1 vote119 views2 answers
Sql select only first occurrence
SQL
0 vote136 views1 answer
Oracle sql number to varchar2
SQL
0 vote121 views3 answers
Postgresql grant alter table to user
SQL
1 vote121 views1 answer
Sql bitwise operators
SQL
1 vote132 views1 answer
List all triggers in SQL Server
SQL