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 vote151 views1 answer
Interview experience as a call?
SQL
2 votes146 views1 answer
Q operator in sql
SQL
0 vote136 views1 answer
Postgres float to int
SQL
4 votes141 views4 answers
Oracle tablespace tables list
SQL
0 vote195 views1 answer
Sql ssrs
SQL
1 vote147 views3 answers
How to reset id column in sql server
SQL
0 vote94 views1 answer
How to connect sql server using ip address in c#
SQL
22 votes138 views4 answers
Show list of users in mysql
SQL
5 votes163 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
2 votes134 views2 answers
Select multiple tables mysql
SQL