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
Oracle select invalid views
SQL
9 votes151 views6 answers
Oracle substring
SQL
0 vote117 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote116 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote250 views1 answer
Oracle convert int to date
SQL
2 votes186 views1 answer
Tsql copy table
SQL
4 votes119 views1 answer
Delete record mysql query
SQL
0 vote113 views1 answer
Concat column value of same user in mysql
SQL
1 vote120 views1 answer
How much every mysql database record takes from diskspace
SQL
14 votes124 views4 answers
Remove record from table sql
SQL