PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/set-password.html
SET PASSWORD interprets the string as a cleartext string, passes it to the authentication plugin associated with the account, and stores the result returned by the plugin in the account row in the mysql.user system table. If an account is to be ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-aggregate-functions.html
MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-index-optimization.html
MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial Indexes”). MySQL still maintains such indexes, as follows: They are updated for table modifications (INSERT, UPDATE, DELETE, ...The optimizer checks the SRID attribute for indexed columns to determine which spatial reference system (SRS) to use for comparisons, and uses calculations appropriate to the ...
https://dev.mysql.com/doc/refman/8.0/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/8.0/en/views.html
The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Views are stored queries that when invoked produce a result set. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-different-number-nodes.html
See Section 25.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”, for information about how to do this. The files created by the backup on each data node are listed here, where N is the node ID and B is the backup ID. Note When ... It is possible to restore from an NDB backup to a cluster having a different number of data nodes than the original from which the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-choosing-id.html
The collation ID that you choose appears in these contexts: The ID column of the Information Schema COLLATIONS table. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-simple-8bit.html
</charset> In the latin1.xml configuration file, add a <collation> element that names the collation and that contains a <map> element that defines a character code-to-weight mapping table for character codes 0 to 255. This section describes how to ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
The value that it returns to indicate weights is a binary string, so it is convenient to use HEX(WEIGHT_STRING(str)) to display the weights in printable form. Warning User-defined collations are deprecated; you should expect support for them to be ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-update.html
If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. The ...