Search Results
https://dev.mysql.com/doc/refman/8.4/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You can then transfer the file to the other machine and feed it as input to the mysql client. Note If ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
For example: SELECT column1 FROM t1 AS x WHERE x.column1 = (SELECT column1 FROM t2 AS x WHERE x.column1 = (SELECT column1 FROM t3 WHERE x.column2 = t3.column1)); In this statement, x.column2 must be a column in table t2 because SELECT column1 FROM ... A correlated subquery is a subquery that contains a reference to a table that also appears in the outer ...
https://dev.mysql.com/doc/refman/8.4/en/creating-many-tables.html
If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table that has to be opened, another must be closed. If you have many MyISAM tables in the same database ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files-using-mysql.html
MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...
https://dev.mysql.com/doc/refman/8.4/en/csv-storage-engine.html
If you examine the test.CSV file in the database directory created by executing the preceding statements, its contents should look like this: "1","record one" "2","record two" This format can be read, and even written, by spreadsheet applications ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-file-removal.html
ddl_log.log file: The file contained records of metadata operations generated by data definition statements such as DROP TABLE and ALTER TABLE. In previous MySQL releases, dictionary data was partially stored in metadata files. Issues with ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary.html
MySQL Server incorporates a transactional data dictionary that stores information about database objects. In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
For example, to use mask_db as the database name, execute this statement: $> mysql -u root -p -e "CREATE DATABASE IF NOT EXISTS mask_db" Enter password: (enter root password here) Run masking_functions_install.sql to add the masking_dictionaries ...
https://dev.mysql.com/doc/refman/8.4/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/8.4/en/displaying-traces.html
As noted previously, you should ensure that end_markers_in_json is OFFwhen executing the SELECT INTO statement, so that the output is valid JSON. Examining a trace in the mysql command-line client can be made less difficult using the pager less ...