PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
Setting the SQL Mode The default SQL mode in MySQL 9.7 includes these modes: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION. Note With TRADITIONAL mode enabled, an ...
https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html
WEEK() Return the week number WEEKDAY() Return the weekday index WEEKOFYEAR() Return the calendar week of the date (1-53) WEIGHT_STRING() Return the weight string for a string XOR Logical XOR YEAR() Return the year YEARWEEK() Return the year and ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Temporal types: DATE, DATETIME, and TIMESTAMP are supported, and are converted to JavaScript Date values. Table 27.3 Type Conversion: JavaScript Dates to MySQL JavaScript TypeMySQL DATEMySQL DATETIME, TIMESTAMPMySQL YEARnull or undefined NULL NULL ... Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-range.html
Rather than splitting up the table data according to store number, you can use an expression based on one of the two DATE columns instead. You want to use a column containing date or time values, or containing values arising from some other series.
https://dev.mysql.com/doc/refman/9.7/en/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. Instead, it is better to store a fixed value such as date of birth. Then, whenever you need age, you can calculate it as the difference between the current date and the ...You want a table that contains a record for each of your ...
https://dev.mysql.com/doc/refman/9.7/en/mysqldump.html
This tool provides high performance for InnoDB backups with minimal disruption; it can also back up tables from MyISAM and other storage engines; it also provides a number of convenient options to accommodate different backup scenarios. --dump-date ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-types.html
A very common use of database partitioning is to segregate data by date. Some database systems support explicit date partitioning, which MySQL does not implement in 9.7. However, it is not difficult in MySQL to create partitioning schemes based on ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/expressions.html
For the - operator, INTERVAL expr unit is permitted only on the right side, because it makes no sense to subtract a date or datetime value from an interval. This section lists the grammar rules that expressions must follow in MySQL and provides ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html
CAST(expr AS type [ARRAY]) CAST(timestamp_value AT TIME ZONE timezone_specifier AS DATETIME[(precision)]) timezone_specifier: [INTERVAL] '+00:00' | 'UTC' With CAST(expr AS type syntax, the CAST() function takes an expression of any type and produces ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...