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/myisamchk-general-options.html
stats_method influences how NULL values are treated for index statistics collection when the --analyze option is given. The options described in this section can be used for any type of table maintenance operation performed by myisamchk. The ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
If character_set_results has a value of NULL or binary, no conversion occurs. This section describes how the MySQL server uses character sets for constructing error messages. For information about the language of error messages (rather than the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
For management nodes and API nodes other than SQL nodes, the value of this column is NULL. This table contains information about NDB Cluster node processes; each node is represented by the row in the table. Only nodes that are connected to the ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
For example, if you specified NOT NULL and an explicit DEFAULT value, you should also provide them in the ALTER TABLE statement. To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. For information about restrictions on view use, see Section 23.9, “Restrictions on Views”. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
The TP_THREAD_STATE table has one row per thread created by the thread pool to handle connections. The TP_THREAD_STATE table has these columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system tables. This information comes from the InnoDB internal system tables (also referred to as the InnoDB data dictionary), which cannot be queried ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/literals.html
These include strings, numbers, hexadecimal and bit values, boolean values, and NULL. This section describes how to write literal values in MySQL. The section also covers various nuances that you may encounter when dealing with these basic types in ...