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 votes338 views1 answer
Q operator in plsql
SQL
19 votes323 views6 answers
What is mySQL
SQL
0 vote330 views1 answer
Vs 2019 connect to local mysql database
SQL
1 vote328 views1 answer
Deleting database in sql
SQL
0 vote323 views1 answer
Every Derived yable must have its own alias
SQL
1 vote292 views1 answer
SQLSTATE[HY000] [2002]
SQL
2 votes324 views1 answer
Query any digits record
SQL
0 vote294 views1 answer
Create column that already exists mysql
SQL
6 votes374 views4 answers
Mysql get random row
SQL
0 vote316 views1 answer
Start and stop mysql
SQL