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 vote185 views1 answer
Mysql select last 15 minutes
SQL
1 vote183 views3 answers
Mariadb add foreign key
SQL
2 votes181 views1 answer
Add 2 hours to current time in MySQL
SQL
4 votes182 views2 answers
Postgres update single column
SQL
0 vote216 views1 answer
Sql requete number pair
SQL
0 vote196 views1 answer
Psql check if sql script is valid
SQL
2 votes199 views1 answer
How to get weekday from old date in sql
SQL
15 votes198 views3 answers
Mysql update add to existing value
SQL
0 vote188 views1 answer
Mysql read row
SQL
0 vote227 views1 answer
Sql server beginning of month
SQL