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 vote366 views1 answer
Sintaxis SELECT sql
SQL
0 vote375 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
10 votes384 views2 answers
Oracle alter sequence nextval
SQL
24 votes348 views4 answers
Mssql get all table names
SQL
5 votes352 views1 answer
Mysql get last day of month
SQL
0 vote342 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote394 views1 answer
Sql query to force the database to be drop
SQL
1 vote385 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote390 views1 answer
Python mysql show databases
SQL
1 vote348 views1 answer
What is intersect
SQL