MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 51 to 60 of 66 total results

https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html

When you add a primary key using the ALGORITHM=COPY clause, MySQL converts NULL values in the associated columns to default values: 0 for numbers, an empty string for character-based columns and BLOBs, and 0000-00-00 00:00:00 for DATETIME. Online ...

11.3 Keywords and Reserved Words

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

25.5.12 ndb_error_reporter — NDB Error-Reporting Utility

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

29.12.21.2 The error_log Table

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

17.12.8 Online DDL Limitations

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

28.3.8 The INFORMATION_SCHEMA COLUMNS Table

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

Displaying 51 to 60 of 66 total results