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 vote191 views1 answer
Select from column mysql
SQL
0 vote293 views1 answer
Sqlalchemy _in array sqlite
SQL
5 votes232 views3 answers
Select tables from mysql database
SQL
5 votes204 views3 answers
Postgres show databases
SQL
0 vote211 views1 answer
How to find table lock and row lock in mysql
SQL
24 votes197 views5 answers
Sql server insert into select
SQL
4 votes198 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote205 views1 answer
Intellij idea add mysql connector
SQL
0 vote189 views2 answers
Select limit ms sql
SQL
0 vote228 views1 answer
Mysql error codeigniter
SQL