Search Results
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification for a string column, you can create an index that uses only the first N characters of the column.
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
MySQL displays DATE values in 'YYYY-MM-DD' format, but permits assignment of values to DATE columns using either strings or numbers. MySQL displays DATETIME values in 'YYYY-MM-DD hh:mm:ss[.fraction]' format, but permits assignment of values to ...
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. Consequently, when this mode is enabled, string ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-general-info.html
The version string displayed by the mysql client supplied with the MySQL NDB Cluster distribution uses this format: mysql-mysql_server_version-cluster mysql_server_version represents the version of the MySQL Server on which the NDB Cluster release ... MySQL NDB Cluster uses the MySQL server with the NDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mgm-client-commands.html
CONNECT connection-string Connects to the management server indicated by the connection string. PROMPT [prompt] Changes the prompt shown by ndb_mgm to the string literal prompt. mgm#1: PROMPT mymgm > mymgm > PROMPT 'mymgm:' 'mymgm:' PROMPT mymgm: ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
The value is one of int, uint (unsigned integer), double, decimal, datetime, or string (includes character and binary strings). The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-encryption-options.html
See Chapter 10, Encryption for Backups for more details and usage examples for the encryption and decryption functions of MySQL Enterprise Backup. --key=STRING Command-Line Format --key=KEY Type String The symmetric key for encryption and decryption ... These options are for creating encrypted single-file backups and for decrypting ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-set-trace.html
end_time: Date and time string denoting the end of the span. forbidden_function_with_connection_sharing: The statement contains functions or keywords which are not possible with connection sharing. MySQL Router supports tracing of statements as ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
The following code snippets illustrate this: string sql = "SELECT * FROM TestTable"; ... This tutorial teaches you how to use the MySqlScript class. Depending on the circumstances, this can be more convenient than using the MySqlCommand approach.