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/resignal.html
RESIGNAL makes it possible to both handle an error and return the error information. Otherwise, by executing an SQL statement within the handler, information that caused the handler's activation is destroyed. RESIGNAL also can make some procedures ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/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. near 'interval (begin INT, end INT)' BEGIN and END are keywords but not reserved, so their use as ...This may also be true for the names of built-in ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance.html
Expelled members automatically attempt to rejoin the group, and are brought up to date by distributed recovery. Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated recovery. If a member ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
Note Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and ...Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which are discussed in Section 8.2.3, “Grant ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...Built-In Function Name Parsing Function Name Resolution Built-In Function ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. The easiest way to accomplish this ...There are two key points to keep in mind: For a table to be replicated in the cluster, it must use the NDBCLUSTER storage ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgm.html
--connect-retries=# Command-Line Format --connect-retries=# Type Numeric Default Value 3 Minimum Value 0 Maximum Value 4294967295 This option specifies the number of times following the first attempt to retry a connection before giving up (the ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
If one of the arguments is a TIMESTAMP or DATETIME column and the other argument is a constant, the constant is converted to a timestamp before the comparison is performed. To compare the operands as DATETIME values, use CAST() to explicitly convert ...To be safe, always use complete datetime, date, or time strings when doing ... When an operator is used with ...mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
For example, the following statement finds rows matching the WHERE clause, sorts them by timestamp_column, and deletes the first (oldest) one: DELETE FROM somelog WHERE user = 'jcole' ORDER BY timestamp_column LIMIT 1; ORDER BY also helps to delete ...Single-Table Syntax DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name [[AS] tbl_alias] [PARTITION (partition_name [, partition_name] ...)] [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] The DELETE statement deletes rows from tbl_name and returns the number of deleted ...