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/upgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. This section describes the steps to upgrade a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
For example, before upgrading from MySQL 5.6 to 5.7, use mysqladmin from MySQL 5.6 as follows: C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, invoke mysqladmin with ... There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
To install functions from the library file, use the CREATE FUNCTION statement. The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. MySQL Enterprise Encryption functions are ...
https://dev.mysql.com/doc/refman/5.7/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is valid standard SQL, but -- is interpreted as the start of a comment, and part of the expression is discarded. The ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
Condition filtering enables the optimizer to use other relevant conditions in the WHERE clause not taken into account by the access method, and thus improve its prefix row count estimates. It was not already taken into account by the access method.
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. This is like executing a SHUTDOWN statement without having to connect to the server (which ...Some command interpreters associate certain key sequences with signals, such as Control+C to send a SIGINT ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
When the body of a view requires row-based replication, the statement creating the view also uses it. For example, this occurs when the statement creating a view uses the UUID() function. (Bug #12092, Bug #30244) When USER(), CURRENT_USER(), or ...
https://dev.mysql.com/doc/refman/5.7/en/call.html
CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE PROCEDURE. To get back a value from a procedure using an OUT or INOUT parameter, pass the parameter by means of a ...Stored procedures that take no arguments can be invoked without ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...