Search Results
https://dev.mysql.com/doc/refman/8.4/en/se-csv-limitations.html
All tables that you create using the CSV storage engine must have the NOT NULL attribute on all columns.
https://dev.mysql.com/doc/refman/8.4/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/8.4/en/server-logs.html
You can tell the server to write general query and slow query entries to log tables, log files, or both. MySQL Server has several logs that can help you find out what activity is taking place. The following log-specific sections provide information ...
https://dev.mysql.com/doc/refman/8.4/en/server-plugins.html
The plugins supported by this interface include, but are not limited to, storage engines, INFORMATION_SCHEMA tables, full-text parser plugins, and server extensions. MySQL supports an plugin API that enables creation of server plugins. Plugins can ...
https://dev.mysql.com/doc/refman/8.4/en/set-default-role.html
SET DEFAULT ROLE requires these privileges: Setting the default roles for another user requires the global CREATE USER privilege, or the UPDATE privilege for the mysql.default_roles system table. SET DEFAULT ROLE {NONE | ALL | role [, role ] ...} ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
SET PASSWORD interprets the string as a cleartext string, passes it to the authentication plugin associated with the account, and stores the result returned by the plugin in the account row in the mysql.user system table. SET PASSWORD [FOR user] ...
https://dev.mysql.com/doc/refman/8.4/en/set-resource-group.html
Thread IDs can be determined from the Performance Schema threads table. SET RESOURCE GROUP group_name [FOR thread_id [, thread_id] ...] SET RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource Groups”). If the ...
https://dev.mysql.com/doc/refman/8.4/en/show-character-set.html
Character set information is also available from the INFORMATION_SCHEMA CHARACTER_SETS table. SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html
row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */ SHOW CREATE DATABASE quotes table and column names ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...