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 vote156 views2 answers
Datetrunc hour snowflake
SQL
1 vote159 views1 answer
Count mysql server db tables
SQL
0 vote156 views1 answer
Ajouter une clé etrangere mysql
SQL
3 votes151 views1 answer
Create a table with an id in mysql
SQL
6 votes160 views1 answer
Postgresql add enum value
SQL
4 votes192 views1 answer
Mysql delete last row
SQL
0 vote156 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
15 votes158 views3 answers
Find duplicate keys in mysql
SQL
0 vote153 views1 answer
Mysql grant grant option
SQL
0 vote168 views1 answer
Renommer schema sql
SQL