Search Results
https://dev.mysql.com/doc/refman/8.4/en/hexadecimal-literals.html
For example, a hexadecimal literal assigned to a user-defined variable is a binary string by default. Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the ...
https://dev.mysql.com/doc/refman/8.4/en/history.html
The name of the MySQL Dolphin (our logo) is “Sakila,” which was chosen from a huge list of names suggested by users in our “Name the Dolphin” contest. We started out with the intention of using the mSQL database system to connect to our ...
https://dev.mysql.com/doc/refman/8.4/en/index.html
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users. Including MySQL NDB Cluster 8.4 Abstract This is the MySQL Reference Manual. It documents MySQL 8.4 through 8.4.6, as well as NDB ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-column-privileges-table.html
The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. TABLE_CATALOG The name of ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-enabled-roles-table.html
The ENABLED_ROLES table has these columns: ROLE_NAME The user name part of the granted role. The ENABLED_ROLES table provides information about the roles that are enabled within the current session. IS_DEFAULT YES or NO, depending on whether the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-optimizer-trace-table.html
INSUFFICIENT_PRIVILEGES If a traced query uses views or stored routines that have SQL SECURITY with a value of DEFINER, it may be that a user other than the definer is denied from seeing the trace of the query. The OPTIMIZER_TRACE table provides ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-profiling-table.html
Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.32, “SHOW PROFILE Statement”). The table is empty unless the profiling session variable is set to 1. Note This table is ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. TABLE_CATALOG The name of ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schemata-table.html
Caution Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with SHOW DATABASES or by examining the SCHEMATA table of INFORMATION_SCHEMA, except ... A ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO otherwise. TABLE_CATALOG The name of ...