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