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 vote120 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote150 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
6 votes127 views4 answers
How to remove unique key in mysql
SQL
0 vote134 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
3 votes259 views6 answers
Sql unique select
SQL
0 vote137 views1 answer
New rails app with mysql
SQL
0 vote131 views1 answer
T-sql check if data exists
SQL
3 votes128 views2 answers
Mysql time
SQL
2 votes145 views2 answers
Checking data type in sql server
SQL
20 votes138 views5 answers
Reset auto increment mysql
SQL