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 vote125 views10 answers
Sql statement checker corrector
SQL
0 vote126 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote118 views1 answer
CREATE MULTIPLE FK
SQL
2 votes198 views1 answer
Oracle run_duration to number
SQL
1 vote128 views1 answer
Mysql query where in select
SQL
2 votes134 views2 answers
Oracle multiple insert
SQL
0 vote165 views1 answer
Mysql 3 months ago
SQL
0 vote131 views1 answer
Mysql begin statement
SQL
0 vote167 views1 answer
Drop domain postgresql
SQL
0 vote131 views1 answer
Get number of table colums in sql query
SQL