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/replication-howto-repuser.html
Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to connect. Although you do not have to create an account specifically for replication, you should be ...The user name is specified by the SOURCE_USER | MASTER_USER option of the CHANGE REPLICATION SOURCE TO statement (from MySQL 8.0.23) or CHANGE MASTER TO statement (before MySQL 8.0.23) when you set up a ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-index-optimization.html
(Prior to MySQL 8.0, the optimizer performs comparisons of SPATIAL index values using Cartesian calculations; the results of such operations are undefined if the column contains values with non-Cartesian SRIDs.) For comparisons to work properly, ...
https://dev.mysql.com/doc/refman/8.0/en/statement-labels.html
Label use for those statements follows these rules: begin_label must be followed by a colon. If end_label is present, it must be the same as begin_label. To refer to a label within the labeled construct, use an ITERATE or LEAVE statement.
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
WHERE subquery_where AND outer_expr=inner_expr) After the conversion, MySQL can use the pushed-down equality to limit the number of rows it must examine to evaluate the subquery. Essentially, there must be different ways to execute the subquery ...
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
(DROP FUNCTION is also used to drop loadable functions; see Section 15.7.4.2, “DROP FUNCTION Statement for Loadable Functions”.) To drop a stored routine, you must have the ALTER ROUTINE privilege for it. See Section 27.2.2, “Stored Routines ... DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-collections-add.html
The value of the _id field must be unique among all documents in the same collection. To work with the collections in a schema, use the db global object to access the current schema. In this example we are using the world_x schema imported ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-add.html
The value of the _id field must be unique among all documents in the same collection. To work with the collections in a schema, use the db global object to access the current schema. In this example we are using the world_x schema imported ...
https://dev.mysql.com/doc/refman/8.0/en/restart.html
For example, SET PERSIST_ONLY can be used at runtime to make configuration changes to system variables that can be set only at server startup, but the server must still be restarted for those changes to take effect. One use for RESTART is when it is ...Because status variables are initialized for each server startup and do not persist across restarts, Com_restart normally has a value of zero, but can be nonzero if RESTART statements were executed but ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
Note The following examples use DEFAULT 0, a default that can produce warnings or errors depending on whether strict SQL mode or the NO_ZERO_DATE SQL mode is enabled. If a TIMESTAMP or DATETIME column definition includes an explicit fractional ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. The grammar shown here is based on that given in the sql/sql_yacc.yy file of ...