MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 31 to 40 of 119 total results

16.1.6.4 Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html

Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which ...

1.5 How to Report Bugs or Problems

https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html

Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at https://dev.mysql.com/doc/. We try to keep the manual up to date by updating ...

11.2 Date and Time Data Types

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html

The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. Each temporal type has a range of valid values, as well as a “zero” value that may be used when you specify an invalid value that MySQL ...

9.5 Expressions

https://dev.mysql.com/doc/refman/5.7/en/expressions.html

This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...

11.2.7 Fractional Seconds in Time Values

https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html

MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, ...

13.2.9.2 JOIN Clause

https://dev.mysql.com/doc/refman/5.7/en/join.html

MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... index_hint: { USE {INDEX|KEY} ...

8.10.3.1 How the Query Cache Operates

https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html

Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, “Query Cache Configuration”, describes how to control whether it is ...

B.3.4.2 Problems Using DATE Columns

https://dev.mysql.com/doc/refman/5.7/en/using-date.html

You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...

13.1.18 CREATE TABLE Statement

https://dev.mysql.com/doc/refman/5.7/en/create-table.html

| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...

12.7 Date and Time Functions

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html

This section describes the functions that can be used to manipulate temporal values. See Section 11.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...

Displaying 31 to 40 of 119 total results