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 vote172 views1 answer
Oracle search columns in schema
SQL
-3 votes166 views1 answer
Remove spaces sql 2008
SQL
0 vote168 views1 answer
Sql common columns
SQL
0 vote168 views1 answer
Oracle query to see what scema i am working in
SQL
3 votes173 views1 answer
Select count from table mysql
SQL
0 vote162 views1 answer
Cast for print sql
SQL
0 vote181 views1 answer
How do you insert boolean to postgresql
SQL
0 vote193 views1 answer
R write csv without index
SQL
1 vote159 views2 answers
T-sql random number for each row
SQL
1 vote157 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL