MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 181 to 190 of 197 total results

19.1.6.3 Replica Server Options and Variables

https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html

The server creates relay log files in sequence by adding a numeric suffix to the base name. replica_exec_mode Command-Line Format --replica-exec-mode=mode Introduced 8.0.26 System Variable replica_exec_mode Scope Global Dynamic Yes SET_VAR Hint ...

15.4.1.2 RESET MASTER Statement

https://dev.mysql.com/doc/refman/8.0/en/reset-master.html

Note This statement is replaced in later versions of MySQL by RESET BINARY LOGS AND GTIDS, and should be considered deprecated. See RESET BINARY LOGS AND GTIDS Statement, in the MySQL 8.4 Manual, for more information. RESET MASTER [TO ...

15.2.13 SELECT Statement

https://dev.mysql.com/doc/refman/8.0/en/select.html

LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants, with these exceptions: Within prepared statements, LIMIT parameters can be specified using ? placeholder markers. SELECT [ALL | DISTINCT | DISTINCTROW ] ...

7.1.7 Server Command Options

https://dev.mysql.com/doc/refman/8.0/en/server-options.html

--check-table-functions=value Command-Line Format --check-table-functions=value Introduced 8.0.42 Type Enumeration Default Value ABORT Valid Values WARNABORT When performing an upgade of the server, we scan the data dictionary for functions used in ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...

7.1.6 Server Status Variable Reference

https://dev.mysql.com/doc/refman/8.0/en/server-status-variable-reference.html

The following table lists all status variables applicable within mysqld. The last column indicates whether the scope for each variable is Global, Session, or both. Please see the corresponding item descriptions for details on setting and using the ...

14.8.1 String Comparison Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html

Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...

13.3.1 String Data Type Syntax

https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html

In this case, comparison and sorting are based on numeric character code values. The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that ...

13.2.9 2-Digit Years in Dates

https://dev.mysql.com/doc/refman/8.0/en/two-digit-years.html

For YEAR, the rules are the same, with this exception: A numeric 00 inserted into YEAR results in 0000 rather than 2000. Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form ...

15.2.17 UPDATE Statement

https://dev.mysql.com/doc/refman/8.0/en/update.html

The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/8.0/en/user-variables.html

User variables are written as @var_name, where the variable name var_name consists of alphanumeric characters, ., _, and $. To assign a hexadecimal or bit value as a number to a user variable, use it in numeric context. You can store a value in a ...

Displaying 181 to 190 of 197 total results