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 vote327 views1 answer
T-SQL Create Trigger
SQL
0 vote317 views1 answer
Add multiple field in table sql
SQL
2 votes387 views5 answers
Tablespace ORACLE
SQL
0 vote322 views1 answer
Isnull in sqlite
SQL
0 vote336 views1 answer
Sqlite3_open_v2
SQL
0 vote311 views1 answer
How to get data between a last week in mysql
SQL
0 vote317 views1 answer
Django mssql backend
SQL
1 vote313 views1 answer
Calculate age in sql postgresql
SQL
0 vote306 views1 answer
TSQL function split string
SQL
48 votes367 views3 answers
Psql create database
SQL