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 vote391 views1 answer
Drop view in mysql
SQL
0 vote344 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote362 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
1 vote341 views1 answer
Get all db sizes in mysql server
SQL
0 vote291 views1 answer
Query for maximum salary
SQL
1 vote316 views1 answer
Autocommit mysql
SQL
8 votes291 views8 answers
Second highest salary in mysql
SQL
0 vote337 views1 answer
Execut sql python
SQL
0 vote325 views1 answer
Oracle index hint
SQL
1 vote329 views1 answer
Select inside insert query
SQL