Search Results
https://dev.mysql.com/doc/refman/9.7/en/select-into.html
Note Any file created by INTO OUTFILE or INTO DUMPFILE is owned by the operating system user under whose account mysqld runs. For the INTO var_list variant: var_list names a list of one or more variables, each of which can be a user-defined ...INTO ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-using-an-anomaly-detection-model.html
To create summaries, use the following options: summarize_logs: Enable summaries by setting this to TRUE. For the option to set the user name, you can set it to NULL. The following example runs ML_PREDICT_TABLE on the testing dataset previously ...
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Only Export Privileges Select this option to update the privileges of existing users, as opposed to creating new users. Exporting privileges for nonexistent users will result in errors when you execute the CREATE script. Forward engineering enables ...Figure 9.36 SQL Export Options The SQL Export Options displays the following facilities: Output SQL Script File: To specify the output file name, enter it into the Output SQL Script File field, or use the Browse button to select a ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-ssl-pfx.html
Creating a Certificate File to Use with the .NET Client From the directory server-repository-root/mysql-test/std_data, issue the following command. Connecting to the Server Using a File-Based Certificate Use the client.pfx file that you created in ...Instead, Windows includes a certificate store that provides platform-dependent certificates in PFX ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-ssl-pfx.html
Creating a Certificate File to Use with the .NET Client From the directory server-repository-root/mysql-test/std_data, issue the following command. Connecting to the Server Using a File-Based Certificate Use the client.pfx file that you created in ...Instead, Windows includes a certificate store that provides platform-dependent certificates in PFX ...
https://dev.mysql.com/doc/refman/9.7/en/drop-role.html
To use this statement, you must have the global DROP ROLE or CREATE USER privilege. Users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. Users who have the DROP ROLE privilege can use this ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/9.7/en/preface.html
If you are using a Commercial release of MySQL 9.7, see the MySQL 9.7 Commercial Release License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this ...
https://dev.mysql.com/doc/refman/9.7/en/system-variable-privileges.html
Suppose that an administrator has created the following role to confer the ability to set restricted session system variables: CREATE ROLE set_session_sysvars; GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO set_session_sysvars; Any user granted the ...In ...