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

3 votes232 views2 answers
Sqlite show table definition
SQL
0 vote253 views1 answer
Alternative for LIMIT sql
SQL
7 votes229 views3 answers
Restore postgres database from sql file
SQL
2 votes201 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote214 views1 answer
Oracle lower in where clause
SQL
11 votes236 views5 answers
Laravel db facade
SQL
0 vote193 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote203 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
1 vote203 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote292 views1 answer
How to find sql server name
SQL