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 vote338 views1 answer
Call function in query sql server
SQL
1 vote352 views1 answer
Blob datatype in mysql
SQL
0 vote351 views1 answer
Turnicate in mysql
SQL
11 votes357 views1 answer
Mysql order by two columns priority
SQL
0 vote341 views1 answer
Price-colour
SQL
0 vote349 views1 answer
Drop all data from tables
SQL
0 vote389 views1 answer
Postgresql print sessions using the database
SQL
1 vote378 views1 answer
Connect to mysql database ubuntu
SQL
1 vote363 views1 answer
Check current sequence value postgres
SQL
0 vote357 views1 answer
How to select an index in oracle sql
SQL