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 vote315 views1 answer
Implicit inner join table alias with id values
SQL
0 vote323 views1 answer
Get who is hired in specific month in sql
SQL
0 vote351 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
13 votes357 views3 answers
Insert mysql ifile nto database
SQL
11 votes385 views1 answer
Oracle insert from select
SQL
-2 votes328 views1 answer
Use of where in left join in mysql
SQL
1 vote337 views1 answer
Mysql return text after a final full stop
SQL
0 vote330 views1 answer
Phpmyadmin tabellentyp ändern
SQL
6 votes324 views4 answers
Sqlite drop table
SQL
-3 votes422 views8 answers
Sql to c# linq converter online
SQL