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 vote116 views1 answer
Typical max-connect-errors mysql
SQL
0 vote105 views1 answer
Supprimer les valeur d'une table mysql
SQL
8 votes124 views1 answer
My sql version
SQL
0 vote96 views2 answers
Mysql two column combination unique
SQL
1 vote129 views3 answers
How to create a table structure from another table in mysql
SQL
1 vote103 views3 answers
What is union in sql
SQL
1 vote101 views1 answer
Python escape mysql
SQL
1 vote106 views2 answers
Test sqlsrv connection
SQL
2 votes99 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote118 views1 answer
On delete set default
SQL