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

1 vote343 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote359 views1 answer
Mysql insert into select transaction c#
SQL
1 vote359 views1 answer
Psql search table
SQL
3 votes368 views2 answers
To_char sql
SQL
2 votes346 views1 answer
How to make insert script from table in SQL server
SQL
0 vote368 views1 answer
Convert excel into sqllite db using python
SQL
0 vote360 views1 answer
How to get specific salary in sql
SQL
1 vote371 views1 answer
Get create table query existing table mysql
SQL
0 vote349 views1 answer
Mysql cdn link
SQL
0 vote340 views1 answer
Recover deleted data from mysql database
SQL