PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-server-id.html
The server ID is 65535 by default, but this can be changed with --stop-never-slave-server-id. When invoked with the --read-from-remote-server option, mysqlbinlog connects to a MySQL server, specifies a server ID to identify itself, and requests ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-server.html
This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations. The following discussion covers these MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump db1 > dump.sql On Server 2: $> mysqladmin create db1 $> mysql db1 < dump.sql You can specify a different database name in this case, so omitting --databases from the mysqldump command enables you to dump data from one ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-tips.html
This section surveys techniques that enable you to use mysqldump to solve specific problems: How to make a copy a database How to copy a database from one server to another How to dump stored programs (stored procedures and functions, triggers, and ...
https://dev.mysql.com/doc/refman/5.7/en/native-pluggable-authentication.html
This section describes mysql_native_password, which implements authentication against the mysql.user system table using the native password hashing method. MySQL includes two plugins that implement native authentication; that is, authentication ...
https://dev.mysql.com/doc/refman/5.7/en/old-native-pluggable-authentication.html
This section describes mysql_old_password, which implements authentication against the mysql.user system table using the older (pre-4.1) native password hashing method. MySQL includes two plugins that implement native authentication; that is, ...
https://dev.mysql.com/doc/refman/5.7/en/open.html
OPEN cursor_name This statement opens a previously declared cursor. For an example, see Section 13.6.6, “Cursors”. ...
https://dev.mysql.com/doc/refman/5.7/en/opengis-geometry-model.html
In this model, each geometric object has the following general properties: It is associated with a spatial reference system, which describes the coordinate space in which the object is defined. The set of geometry types proposed by OGC's SQL with ...
https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html
Operator precedences are shown in the following list, from highest precedence to the lowest. Operators that are shown together on a line have the same precedence. When used as a comparison operator, it has the same precedence as <=>, >=, >, <=, <, ...
https://dev.mysql.com/doc/refman/5.7/en/optimization.html
This chapter explains how to optimize MySQL performance and provides examples. Depending on your job role (developer, DBA, or a combination of both), you might optimize at the level of individual SQL statements, entire applications, a single ...