PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview and more detailed description of the properties of ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-conversion.html
To perform the comparison by ignoring the time part of the DATETIME value instead, use the CAST() function in the following way: date_col = CAST(datetime_col AS DATE) Conversion of TIME and DATETIME values to numeric form (for example, by adding +0) ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
(They convert the values to numbers, losing everything after the first nonnumeric character.) To work around this problem, convert to numeric units, perform the aggregate operation, and convert back to a temporal value. The date and time data types ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
MySQL automatically converts a date or time value to a number if the value is used in numeric context and vice versa. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. Each temporal type ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
May be followed by a list (containing only one modifier) giving a numeric maximum trace level, beyond which no output occurs for either debugging or tracing macros. The MySQL server and most MySQL clients are compiled with the DBUG package ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in ...
https://dev.mysql.com/doc/refman/8.0/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...That way, each small table can have a primary key for fast lookups of its data, and you can query just the set of columns that you need using a join ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
group_replication_flow_control_mode Command-Line Format --group-replication-flow-control-mode=value System Variable group_replication_flow_control_mode Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value QUOTA Valid ...
https://dev.mysql.com/doc/refman/8.0/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, ...