Search Results
https://dev.mysql.com/doc/refman/8.4/en/features.html
Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of rows that were changed (affected), or to return the number of rows matched instead by setting a flag when connecting to the server. This section describes some of the important ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
This user must have been created on the remote server, and must have suitable privileges to perform the required actions (SELECT, INSERT, UPDATE, and so forth) on the remote table. To use the first method, you must specify the CONNECTION string ...
https://dev.mysql.com/doc/refman/8.4/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
Insert the name of the custom schema to be used as the firewall database. MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 8.4.7.1, “Elements of MySQL Enterprise Firewall”.
https://dev.mysql.com/doc/refman/8.4/en/floating-point-types.html
MySQL performs rounding when storing values, so if you insert 999.00009 into a FLOAT(7,4) column, the approximate result is 999.0001. The FLOAT and DOUBLE types represent approximate numeric data values. MySQL uses four bytes for single-precision ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
FLUSH TABLES WITH READ LOCK does not prevent the server from inserting rows into the log tables (see Section 7.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). | tables_option } flush_option: { BINARY LOGS | ENGINE ...
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
To alleviate the problem, take the following actions: To continue, you only have to free enough disk space to insert all records. This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to ...
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued ...
https://dev.mysql.com/doc/refman/8.4/en/function-loading.html
For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL supports automatic function loading during server ...
https://dev.mysql.com/doc/refman/8.4/en/geometry-well-formedness-validity.html
It is permitted to insert, select, and update geometrically invalid geometries, but they must be syntactically well-formed. For geometry values, MySQL distinguishes between the concepts of syntactically well-formed and geometrically valid. Spatial ...