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 vote293 views1 answer
Mysql into outfile with headers
SQL
0 vote352 views1 answer
Sql basic commands
SQL
6 votes317 views1 answer
Postgres get size of database
SQL
0 vote280 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote520 views1 answer
Get first match in each group mysql query
SQL
0 vote295 views1 answer
Porcentaje sql
SQL
0 vote259 views1 answer
How to set field to null in sql
SQL
0 vote297 views1 answer
Hibernate with springboot mysql
SQL
2 votes299 views2 answers
Useradd postgres
SQL
0 vote290 views1 answer
How to populate a table in MySQL from and existing csv file
SQL