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/selecting-all.html
For example, you may happen to think that the birth date for Bowser does not seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variable-reference.html
The last column indicates whether the scope for each variable is Global, Session, or both. The following table lists all status variables applicable within mysqld. Please see the corresponding item descriptions for details on setting and using the ...
https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses ...
https://dev.mysql.com/doc/refman/5.7/en/show-character-set.html
SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if present, indicates which character set names to match. The WHERE clause can be given to select ...
https://dev.mysql.com/doc/refman/5.7/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-database.html
row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */ SHOW CREATE DATABASE quotes table and column names according to the value of the sql_quote_show_create option. SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
If you do not have privileges for the routine itself, the value displayed for the Create Procedure or Create Function column is NULL. SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. It returns the exact string that can be used ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE ... SHOW CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
SHOW ENGINES output has these columns: Engine The name of the storage engine. SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. This is particularly useful for checking whether a storage engine is ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
SHOW PLUGINS output has these columns: Name The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...