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 vote320 views1 answer
Psql list view rules
SQL
0 vote334 views1 answer
Implicit inner join table alias
SQL
5 votes324 views3 answers
Select tables from mysql database
SQL
0 vote307 views1 answer
Replace sqlalchemy
SQL
0 vote389 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
8 votes327 views2 answers
Safe update mode in mysql
SQL
0 vote318 views2 answers
Null value in column violates not-null constraint
SQL
11 votes331 views3 answers
Change column name sql server management studio
SQL
0 vote325 views2 answers
How to know the character set of an oracle databes
SQL
0 vote338 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL