Search Results
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
Obtain and Unpack the Distribution Pick the directory under which you want to unpack the distribution and change location into it. Configure the Distribution Change location into the top-level directory of the unpacked distribution: $> cd ... To ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
INTO statement, contains a reference to a column and a declared local variable with the same name, MySQL currently interprets the reference as the name of a variable. The scope of a local variable is the BEGIN ... The variable can be referred to in ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. --join=big_tbl_name, -j big_tbl_name Command-Line Format --join=big_tbl_name Type String Join all tables named on the command line into a single ...This results in much better performance when accessing individual rows, because you only have to uncompress exactly one ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-binary.html
This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by Oracle. For setting up a cluster using precompiled binaries, the first step in the installation process ...
https://dev.mysql.com/doc/refman/8.4/en/parenthesized-query-expressions.html
parenthesized_query_expression: ( query_expression [order_by_clause] [limit_clause] ) [order_by_clause] [limit_clause] [into_clause] query_expression: query_block [set_op query_block [set_op query_block ...]] [order_by_clause] [limit_clause] ...An ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-delimited-text-dumps.html
To reload a table, first change location into the output directory. For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file ...
https://dev.mysql.com/doc/refman/8.4/en/replication-bugs.html
If you have a repeatable test case that demonstrates the bug, please enter it into our bugs database using the instructions given in Section 1.6, “How to Report Bugs or Problems”. In this case, the replication thread stops and waits for you to ... When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
INTO OUTFILE do not overwrite existing files and are writable by everyone. With this privilege, you can read any file into a database table. This could be abused, for example, by using LOAD DATA to load /etc/passwd into a table, which then can be ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-variables.html
Results from queries can be retrieved into local variables using SELECT ... INTO var_list or by opening a cursor and using FETCH ... System variables and user-defined variables can be used in stored programs, just as they can be used outside ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-optimization-with-exists.html
This is done by pushing down an appropriate equality into the subquery's WHERE clause to make it more restrictive. To solve the dilemma of whether or not to push down conditions into the subquery, the conditions are wrapped within “trigger” ...