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 vote297 views1 answer
Get all employee of salary if more than in sql
SQL
15 votes275 views2 answers
How to know the username of postgresql
SQL
0 vote272 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote282 views1 answer
T-SQL - Where Used List (Table/View)
SQL
1 vote286 views1 answer
Postgres start database on linux
SQL
0 vote292 views1 answer
Greater than or equal to symbol in postgres
SQL
46 votes340 views4 answers
Create column sql
SQL
0 vote267 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote278 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote301 views1 answer
Const pool = mysql.createpool()
SQL