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 vote120 views1 answer
Postgres list all triggers
SQL
0 vote102 views1 answer
Cross apply top for each row t1
SQL
0 vote102 views2 answers
Mysql add days to date
SQL
7 votes108 views1 answer
Mysql iif
SQL
3 votes108 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote97 views1 answer
List MySQL Table and Index Size
SQL
0 vote109 views2 answers
Connect to mysql server mac terminal
SQL
0 vote97 views1 answer
Remove from table where
SQL
5 votes138 views2 answers
Add days in oracle sql
SQL
1 vote104 views1 answer
Delete row mssql
SQL