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

1 vote190 views1 answer
Media sql
SQL
0 vote243 views1 answer
Mysql order by where condition sub query
SQL
10 votes199 views4 answers
Primary key in sql
SQL
0 vote210 views1 answer
Rename constraint postgresql
SQL
-1 vote263 views1 answer
Mysql coalesce
SQL
1 vote211 views1 answer
Pl sql insert into table
SQL
1 vote298 views1 answer
Show databases mysql docker
SQL
4 votes193 views1 answer
Oracle table statistics last analyzed
SQL
12 votes205 views6 answers
Select distinct
SQL
1 vote228 views1 answer
Sql server set variable if exists
SQL