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 vote110 views1 answer
How much table store postgres
SQL
0 vote108 views1 answer
Sql server select value large text
SQL
0 vote118 views1 answer
Unique index in mysql
SQL
2 votes112 views1 answer
Sqlite insert if not exists
SQL
4 votes118 views2 answers
Installing sql on ubuntu
SQL
0 vote111 views1 answer
Sql query for getting data with join and count
SQL
5 votes107 views4 answers
Mysql update column with value from another table
SQL
0 vote117 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
0 vote122 views1 answer
Sql get table last modified time
SQL
8 votes99 views1 answer
Oracle add month
SQL