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/verifying-package-integrity.html
After downloading the MySQL package that suits your needs and before attempting to install it, make sure that it is intact and has not been tampered with. If you notice that the MD5 checksum or GPG signatures do not match, first try to download the ...There are three means of integrity checking: MD5 checksums Cryptographic signatures using GnuPG, the GNU Privacy Guard For RPM packages, the built-in RPM integrity verification mechanism The following sections describe how to use these ...
https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html
This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional details. To make sure that you can take advantage of any new capabilities, update your grant ...
https://dev.mysql.com/doc/refman/8.0/en/activestate-perl.html
On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install it. For example, you might try a setting like this: C:\> set ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation-unicode-uca.html
Instead, you begin with an existing “base” collation and describe the new collation in terms of how it differs from the base collation. Table 12.4 MySQL Character Sets Available for User-Defined UCA Collations Character Set Base Collation ...
https://dev.mysql.com/doc/refman/8.0/en/alter-function.html
However, you cannot change the parameters or body of a stored function using this statement; to make such changes, you must drop and re-create the function using DROP FUNCTION and CREATE FUNCTION. ALTER FUNCTION func_name [characteristic ...] ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-problems.html
This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new ...
https://dev.mysql.com/doc/refman/8.0/en/alter-view.html
This statement requires the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement. ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER ...
https://dev.mysql.com/doc/refman/8.0/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. Standard ...MySQL also support extensions to this syntax that enable MySQL-specific SQL to be embedded in the comment; see Section 11.7, ...
https://dev.mysql.com/doc/refman/8.0/en/any-in-some-subqueries.html
Thus, these two statements are the same: SELECT s1 FROM t1 WHERE s1 = ANY (SELECT s1 FROM t2); SELECT s1 FROM t1 WHERE s1 IN (SELECT s1 FROM t2); IN and = ANY are not synonyms when used with an expression list. The syntax means “there is some b to ...The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than ...
https://dev.mysql.com/doc/refman/8.0/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...