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 vote142 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
-1 vote139 views1 answer
How to check table exists or not in postgresql
SQL
7 votes238 views2 answers
Sql empty table
SQL
2 votes136 views3 answers
How to pass password mysql command line
SQL
2 votes157 views1 answer
Grant revoke privileges to mysql username
SQL
8 votes155 views1 answer
Show mysql user table
SQL
7 votes132 views3 answers
How ot change name of column mysql
SQL
3 votes149 views1 answer
Insert into table from another table mysql
SQL
15 votes159 views5 answers
Select all tables sql
SQL
0 vote158 views1 answer
Codigo crear tablas sql server
SQL