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 vote367 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote320 views1 answer
Drop all tables db2
SQL
0 vote320 views1 answer
Sql change date format
SQL
0 vote320 views1 answer
Contact mysql column field
SQL
10 votes336 views1 answer
Oracle dba_dependencies
SQL
0 vote328 views4 answers
How to connect form to database
SQL
3 votes354 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
1 vote331 views1 answer
Mysql select for update ejemplo
SQL
0 vote350 views1 answer
Show tables in cassandra cql
SQL
50 votes401 views6 answers
Install mysql on ubuntu
SQL