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 vote181 views1 answer
Mysql could not fetch tables
SQL
0 vote206 views1 answer
Netstat -tln mysql
SQL
5 votes186 views1 answer
Invalid column name sql
SQL
-1 vote169 views1 answer
Export mysql table to file
SQL
0 vote213 views1 answer
SQL Where-Klausel
SQL
0 vote181 views2 answers
Sql query for getting details by id
SQL
13 votes153 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
1 vote173 views4 answers
Fatal database postgres does not exist
SQL
5 votes198 views2 answers
Mysql create database charset utf8mb4
SQL
6 votes197 views4 answers
Mysql group by date
SQL