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

4 votes279 views5 answers
Get last query in codeigniter 4
SQL
0 vote252 views2 answers
Null value in column violates not-null constraint
SQL
12 votes249 views5 answers
Sql primary key
SQL
0 vote265 views1 answer
Compare two tables to find unmatched records
SQL
0 vote275 views1 answer
Add mysql database to power bi web
SQL
0 vote256 views1 answer
Complete date is 1 year or not sql server
SQL
6 votes275 views2 answers
Mysql timestamp to date
SQL
0 vote239 views1 answer
Mysql autoincrement valor inicial
SQL
0 vote257 views1 answer
Max mysql
SQL
0 vote268 views1 answer
Limit in access query
SQL