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

2 votes201 views1 answer
Node and mysql like
SQL
1 vote219 views1 answer
Sql server datetime vs datetime2
SQL
0 vote225 views1 answer
Sql delete row from table where id
SQL
9 votes223 views1 answer
No sql
SQL
3 votes303 views4 answers
Sql interview questions
SQL
0 vote216 views1 answer
Mysql identified by syntax error
SQL
5 votes232 views1 answer
Get table columns from sql
SQL
1 vote225 views2 answers
Test sqlsrv connection
SQL
13 votes245 views3 answers
List all the tables in sql
SQL
0 vote221 views1 answer
Createdb with postgresql on ubuntu
SQL