16.08.2019| TARTAR| 0 Comments

Subquery In Where Clause Mysql Dump

If your tables are MyISAM, the safest, easiest way to handle this is to pass the flag --lock-all-tables. If your tables are InnoDB then. MySQL subquery is a SELECT query that is embedded in the main SELECT statement. The subquery can be nested inside a SELECT, INSERT.

second-degree relations (aka a Rails has-many-through). mysqldump won't allow a join in the –where clause, but it will allow a subquery.

mysqldump has the --where option to execute a WHERE clause for a given table. Although it is not possible to mysqldump a join query, you can.

© Copyright 2019 - Eco Nature WordPress Theme