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 vote225 views1 answer
Oracle date winter time
SQL
0 vote176 views1 answer
Kannst du deine finger trainieren
SQL
12 votes209 views1 answer
How to change the value of a table in sql
SQL
1 vote235 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote215 views1 answer
Increase date by one day in sql oracle
SQL
3 votes222 views2 answers
Mysql create timestamp column
SQL
5 votes222 views3 answers
Db begintransaction laravel
SQL
0 vote212 views1 answer
Como hacer una consulta en sql
SQL
0 vote219 views1 answer
Mysql changer nom table
SQL
0 vote254 views1 answer
Postgres list all triggers
SQL