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 vote189 views1 answer
Plpgsql if statement
SQL
0 vote202 views1 answer
Microsoft sql server python connection
SQL
0 vote189 views1 answer
Oracle free up space in tablespace
SQL
9 votes200 views1 answer
Sql server get utc date
SQL
2 votes204 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
17 votes195 views6 answers
Mysql import sql file
SQL
0 vote216 views1 answer
No query unable to fetch row sqlite
SQL
0 vote193 views1 answer
Basic structure of sql expression having clause
SQL
0 vote202 views1 answer
Select from column mysql
SQL
18 votes186 views3 answers
Mysql query add column with default string value
SQL