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 vote249 views1 answer
Search mysql database for column
SQL
0 vote248 views1 answer
Shortcut run sql pgadmin
SQL
0 vote223 views1 answer
Oracle enable chain
SQL
3 votes249 views1 answer
Postgresql if null then 0
SQL
49 votes235 views6 answers
Alter table add column
SQL
9 votes221 views4 answers
Mysql show table fields
SQL
0 vote239 views1 answer
Declare date variable sql
SQL
12 votes236 views6 answers
Between in sql
SQL
1 vote221 views1 answer
Sql try catch
SQL
2 votes236 views2 answers
Compare date mysql
SQL