Search Results
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-j-connp-props-blob-clob-processing.html
blobSendChunkSize Chunk size to use when sending BLOB/CLOBs via server-prepared statements. Note that this value cannot exceed the value of 'maxAllowedPacket' and, if that is the case, then this value will be corrected automatically. Since Version ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-mysqlcommand.html
The following SELECT statement includes the mysql_query_attribute_string() loadable function that is used to retrieve the two attributes decared previously and then prints the results. For more readable and convenient syntax, the $ symbol is used in ... The MySqlCommand class represents a SQL statement to execute against a MySQL ...