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 vote188 views1 answer
Php mysqli install
SQL
1 vote182 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote197 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote182 views1 answer
Sql get number of days between two dates
SQL
0 vote179 views1 answer
Cross apply top for each row t1
SQL
5 votes190 views3 answers
Oracle first day of last year
SQL
0 vote188 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
3 votes172 views2 answers
Oracle sql truncate table
SQL
0 vote217 views1 answer
How to find date from date table in sql
SQL
0 vote193 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL