PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/data-masking-elements.html
A set of loadable functions provides an SQL-level API for performing masking and de-identification operations. MySQL Enterprise Data Masking and De-Identification is based on a plugin library that implements these elements: A server-side plugin ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
With one exception, the default value specified in a DEFAULT clause must be a literal constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe functionality). If mysqld does not want to start, verify that you have no my.cnf files ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
To check the number of deleted rows, call the ROW_COUNT() function described in Section 12.15, “Information Functions”. DELETE is a DML statement that removes rows from a table. Single-Table Syntax DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM ...
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
ROW_COUNT has the same value as the ROW_COUNT() function (see Section 12.15, “Information Functions”). SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a ...
https://dev.mysql.com/doc/refman/5.7/en/differences-from-ansi.html
The CAST() function does not support cast to REAL or BIGINT. We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between ...
https://dev.mysql.com/doc/refman/5.7/en/do.html
DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. It cannot be used ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
The Section 19.2, “Setting Up MySQL as a Document Store” section explains how to configure X Plugin on a MySQL Server, so it can function as a document store, and how to install MySQL Shell to use as a client. The following MySQL products ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
If the trigger needs a single result value from the code, you can put the code in a stored function and have the function return the value. Before downgrading from MySQL 5.7, review the information in this section. System Table Changes InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
For example, you can retrieve numeric values from an ENUM column like this: mysql> SELECT enum_col+0 FROM tbl_name; Functions such as SUM() or AVG() that expect a numeric argument cast the argument to a number if necessary. For example, this CREATE ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...