Mysql foreach insert

-- You don't use the VALUES keyword when inserting from a SELECT
INSERT INTO gesdoc_docs_authorizations
    (`gesdoc_docs_id`, `id_profil_do`, `autorisation`, `personal_doc`)
SELECT g.id, d.id, 1, 0
FROM gesdoc_docs g
JOIN users_profil_do d
-- If you don't use an ON clause to specify a join condition, it treats all rows as matching, which results in a full cartesian product of the two tables

Source: stackoverflow.com

Similar codes

0 vote172 views1 answer
Sql create table with references not primary key
SQL
0 vote192 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote177 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote167 views1 answer
Get the First and Last Word from a String or Sentence
SQL
1 vote182 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
5 votes185 views3 answers
Mysql remove unique constraint
SQL
0 vote176 views2 answers
Sql query inner join 3 tables
SQL
1 vote186 views1 answer
Sql select max value from multiple rows
SQL
11 votes178 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote176 views1 answer
How to use select union and loop
SQL