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

12 votes147 views1 answer
How to change the value of a table in sql
SQL
0 vote95 views1 answer
Oracle sql developer script output limit
SQL
10 votes152 views2 answers
Forgot my mysql password mac
SQL
0 vote172 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
103 votes362 views2 answers
Sql server LIKE '%%'
SQL
0 vote150 views1 answer
Mysql set boolean default value
SQL
26 votes142 views2 answers
What is the sql statement that finds duplicate usernames
SQL
10 votes148 views3 answers
How to fetch first 5 characters in sql
SQL
3 votes145 views3 answers
Your password does not satisfy the current policy requirements
SQL
4 votes147 views3 answers
How to describe a table in sqlite3
SQL