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

13 votes227 views3 answers
List all the tables in sql
SQL
0 vote181 views1 answer
Generate random & unique mysql string
SQL
5 votes194 views1 answer
Oracle nls parameters
SQL
0 vote197 views1 answer
Sql server order by nulls last
SQL
0 vote206 views2 answers
Pop sql insert value into
SQL
3 votes201 views3 answers
Mysql order by list
SQL
0 vote200 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote221 views1 answer
Sql express database size limit
SQL
1 vote185 views1 answer
Delete row mssql
SQL
0 vote201 views1 answer
Ubuntu connect to mssql database
SQL