MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 51 to 60 of 65 total results

https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-limitations.html

Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ALGORITHM=COPY do not support ALGORITHM=INPLACE. The following limitations apply to online DDL operations: The table is ...

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/9.7/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 ...

15.2.9 LOAD DATA Statement

https://dev.mysql.com/doc/refman/9.7/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 ...

18.2.1 MyISAM Startup Options

https://dev.mysql.com/doc/refman/9.7/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 ...

13.2.7 What Calendar Is Used By MySQL?

https://dev.mysql.com/doc/refman/9.7/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 ...

25.6.3.2 NDB Cluster Log Events

https://dev.mysql.com/doc/refman/9.7/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 ...

29.12.22.3 The error_log Table

https://dev.mysql.com/doc/refman/9.7/en/performance-schema-error-log-table.html

The LOGGED column stores values using the TIMESTAMP data type, for which values are stored in UTC but displayed when retrieved in the current session time zone; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”. Of the logs the ...

25.5.25 ndb_select_all — Print Rows from an NDB Table

https://dev.mysql.com/doc/refman/9.7/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 ...

28.3.8 The INFORMATION_SCHEMA COLUMNS Table

https://dev.mysql.com/doc/refman/9.7/en/information-schema-columns-table.html

on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these ...

10.9.6 Optimizer Statistics

https://dev.mysql.com/doc/refman/9.7/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 ...

Displaying 51 to 60 of 65 total results