https://dev.mysql.com/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. Its arguments are ...
https://dev.mysql.com/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] The following table ...
https://dev.mysql.com/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. Reserved words are permitted as ...
https://dev.mysql.com/show-columns.html
on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS ...
https://dev.mysql.com/mysql-stmt-fetch.html
Type Length MYSQL_TYPE_TINY 1 MYSQL_TYPE_SHORT 2 MYSQL_TYPE_LONG 4 MYSQL_TYPE_LONGLONG 8 MYSQL_TYPE_FLOAT 4 MYSQL_TYPE_DOUBLE 8 MYSQL_TYPE_TIME sizeof(MYSQL_TIME) MYSQL_TYPE_DATE sizeof(MYSQL_TIME) MYSQL_TYPE_DATETIME sizeof(MYSQL_TIME) ... int ...
https://dev.mysql.com/c-api-data-structures.html
This section describes C API data structures other than those used for prepared statements, the asychronous interface, or the replication stream interface. For information about those, see Section 28.7.9, “C API Prepared Statement Data ...
https://dev.mysql.com/two-digit-years.html
For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates specified with ambiguous year values using these rules: Year values in the range 00-69 are converted to 2000-2069. Date values with two-digit years are ambiguous because the century is ...
https://dev.mysql.com/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. Examples: PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS ...The log consists of a set of binary log files, plus an index file (see Section 5.4.4, “The Binary ...
https://dev.mysql.com/c-api-prepared-statement-problems.html
Here follows a list of the currently known problems with prepared statements: TIME, TIMESTAMP, and DATETIME do not support parts of seconds (for example, from DATE_FORMAT()). When converting an integer to string, ZEROFILL is honored with prepared ...
https://dev.mysql.com/upgrading-from-previous-series.html
Removal of MAXDB means that the TIMESTAMP data type for CREATE TABLE or ALTER TABLE is no longer treated as DATETIME. Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL ...