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/alter-table-problems.html
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 column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-processlist-table.html
row *************************** ID: 10 USER: me HOST: localhost:58834 DB: test COMMAND: Query TIME: 0 STATE: executing INFO: SELECT * FROM performance_schema.processlist ... See Section 5.1.9, “Server Status Variables” TIME The time in seconds ...The MySQL process list indicates the operations currently being performed by the set of threads executing within the ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/case.html
For the second syntax, each WHEN clause search_condition expression is evaluated until one is true, at which point its corresponding THEN clause statement_list executes. When an equal when_value is found, the corresponding THEN clause statement_list ... CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
PROCESS_COUNT The 10ms interval in which the statement that uses this thread is currently executing. 0 means no statement is executing, 1 means it is in the first 10ms, and so forth. The TP_THREAD_STATE table has one row per thread created by the ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
A common error when working with NULL is to assume that it is not possible to insert a zero or an empty string into a column defined as NOT NULL, but this is not the case. The NULL value can be surprising until you get used to it. Conceptually, ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-formats.html
The server uses several logging formats to record information in the binary log. The exact format employed depends on the version of MySQL being used. There are three logging formats: Replication capabilities in MySQL originally were based on ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/5.7/en/firewall.html
MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against lists of accepted statement patterns. Note MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
If connection_control_min_connection_delay and connection_control_max_connection_delay are 1500 and 20000, the adjusted delays for the fourth and subsequent failed connections are 1500 milliseconds, 2000 milliseconds, 3000 milliseconds, and so ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named function_name. (CREATE FUNCTION is also used to created stored functions; see Section ...