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 votes357 views2 answers
Install postgresql
SQL
0 vote348 views1 answer
Create dump file mysql workbench
SQL
3 votes344 views2 answers
How to start postgresql on windows
SQL
0 vote365 views1 answer
Oracle sql number to varchar2
SQL
0 vote421 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote340 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote357 views3 answers
Sql drop all tables
SQL
16 votes369 views1 answer
Mssql int max value
SQL
1 vote330 views1 answer
Set statiscis on in sql server
SQL
-1 vote342 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL