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 vote322 views1 answer
Mysql grant user wildcard database
SQL
0 vote352 views1 answer
Sql select column name like from multiple tables
SQL
0 vote323 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
2 votes314 views2 answers
Laravel query builder toSql
SQL
0 vote316 views1 answer
Drop all tables in azure sql database
SQL
0 vote335 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote322 views1 answer
Oracle list proxy users
SQL
1 vote287 views1 answer
Oracle boolean to varchar
SQL
18 votes323 views6 answers
Create table mysql
SQL
3 votes339 views2 answers
Postgres download
SQL