Search Results
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
An invalid value for a DATETIME, DATE, or TIME column is inserted as the implicit default value, regardless of the SQL mode NO_ZERO_DATE setting. The file can be read from the server host or the client host, depending on whether the LOCAL modifier ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-start.html
The following options to mysqld can be used to change the behavior of MyISAM tables. bulk_insert_buffer_size The size of the tree cache used in bulk insert optimization. Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-calendar.html
For this reason, dates prior to the cutover stored as MySQL DATE or DATETIME values must be adjusted to compensate for the difference. MySQL uses what is known as a proleptic Gregorian calendar. Every country that has switched from the Julian to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-events.html
An event report reported in the event logs has the following format: datetime [string] severity -- message For example: 09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed This section discusses all reportable events, ordered by ...In ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-error-reporter.html
The archive is named ndb_error_report_YYYYMMDDhhmmss.tar.bz2, where YYYYMMDDhhmmss is a datetime string. ndb_error_reporter creates an archive from data node and management node log files that can be used to help diagnose bugs or other problems ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-select-all.html
This does not affect the output of numerals contained in strings or datetime values. ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used ...
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/partitioning-columns-range.html
RANGE COLUMNS partitioning columns are not restricted to integer columns; string, DATE and DATETIME columns can also be used as partitioning columns. Range columns partitioning is similar to range partitioning, but enables you to define partitions ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns.html
The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...