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

2 votes142 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote145 views1 answer
Postgresql how to show table names
SQL
0 vote144 views1 answer
Mysql pad zeros
SQL
4 votes146 views1 answer
Group by mysql and concatenate string
SQL
1 vote138 views1 answer
Show all event schedular on mysql
SQL
0 vote139 views1 answer
Add alternate add column sql
SQL
0 vote134 views1 answer
Qt qsql check if table exist
SQL
0 vote146 views1 answer
Oracle running queries sql
SQL
1 vote147 views1 answer
Round one decimal place mysql
SQL
0 vote143 views1 answer
Narural join
SQL