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 vote191 views1 answer
Sql query inline if
SQL
0 vote182 views1 answer
Sqlalchemy sequence postgresql
SQL
1 vote159 views2 answers
Mysql order by date asc null last
SQL
1 vote157 views1 answer
How refresh navicat tables to see new tables
SQL
14 votes169 views2 answers
Oracle limit rows
SQL
0 vote158 views1 answer
What is the essence of SQL?
SQL
1 vote211 views1 answer
How to get alternate records from a table in sql
SQL
0 vote208 views1 answer
Reindexing all tables sql server
SQL
0 vote155 views1 answer
Limiting query result using where in sql
SQL
0 vote162 views1 answer
Parsing float to int in mysql
SQL