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/programs-overview.html
In addition to the provided SQL functionality, similar to mysql, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. replace A utility program that performs string replacement in the input ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. The mysql_info() C API function returns the number of rows that were matched and updated and the number of ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/5.7/en/dynamic-format.html
Dynamic-format tables have these characteristics: All string columns are dynamic except those with a length less than four. Each row is preceded by a bitmap that indicates which columns contain the empty string (for string columns) or zero (for ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the ...If you specify only the connection name without a table name, the table name of the local table is used ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldumpslow.html
Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. -a Do not abstract all numbers to N and strings to 'S'. -g pattern Type String Consider only queries that match the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
If a numeric expression contains any strings, they are converted to double-precision floating-point values and the expression is approximate. For inserts of strings into numeric columns, conversion from string to number is handled as follows if the ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
gtid_executed System Variable gtid_executed Scope Global Dynamic No Type String Unit set of GTIDs When used with global scope, this variable contains a representation of the set of all transactions executed on the server and GTIDs that have been set ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-disabling.html
The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET statement; for example: SET GLOBAL audit_log_disable = true; Setting audit_log_disable to true disables the audit ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). Use of multiple statements requires that a client is able to send statement strings containing the ; ...A compound statement can contain multiple statements, enclosed by the BEGIN and END ...