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 vote175 views2 answers
Mysql output csv
SQL
1 vote179 views1 answer
Oracle difference between two dates in years
SQL
2 votes175 views3 answers
How to pass password mysql command line
SQL
0 vote180 views1 answer
Copy Table from SQL to CSV
SQL
1 vote200 views1 answer
Tsql random number
SQL
0 vote193 views1 answer
Select amount weeks between two dates mysql
SQL
1 vote189 views1 answer
Delete specific row in sql
SQL
1 vote198 views3 answers
Mysql on delete set null
SQL
3 votes180 views1 answer
How to find names includes in sql
SQL
0 vote156 views1 answer
Hangfire clean script
SQL