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

1 vote252 views1 answer
Sample in sql
SQL
15 votes276 views4 answers
Mysql where value is null
SQL
0 vote245 views1 answer
Select other columns with distinct
SQL
3 votes279 views3 answers
Mysql declare variable
SQL
20 votes279 views3 answers
How to open postgresql in mac
SQL
2 votes261 views1 answer
Plsql block
SQL
1 vote248 views2 answers
Pl sql case
SQL
0 vote270 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
4 votes276 views1 answer
Search column by name mysql
SQL
0 vote478 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL