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 vote256 views1 answer
Postgres foreign key multiple columns
SQL
2 votes289 views1 answer
Get the mysql table columns data type mysql
SQL
1 vote215 views1 answer
Show indices in mysql table
SQL
14 votes267 views1 answer
Excel is not a database
SQL
0 vote203 views1 answer
Sql get count without group by
SQL
8 votes220 views2 answers
Grant all privileges database postgres to user
SQL
19 votes198 views2 answers
Mysql tinyint max value
SQL
0 vote195 views1 answer
Sqlalchemy query sql compiled
SQL
6 votes223 views4 answers
Mysql group by month
SQL
0 vote201 views1 answer
Python list from sql
SQL