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/precision-math-examples.html
Consider the following stored procedure, which adds .0001 to a variable 1,000 times. The floating-point calculation introduces small errors: +--------+------------------+ | d | f | +--------+------------------+ | 1.0000 | 0.99999999999991 | ... This ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = PASSWORD('auth_string') syntax is deprecated in MySQL 5.7 and is removed ...
https://dev.mysql.com/doc/refman/5.7/en/charset-general.html
In real life, most character sets have many characters: not just A and B but whole alphabets, sometimes multiple alphabets or eastern writing systems with thousands of characters, along with many special symbols and punctuation marks. A character ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html
in_max_runtime DECIMAL(20,2): The maximum number of seconds (which can be fractional) to collect data. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. Use NULL to ...
https://dev.mysql.com/doc/refman/5.7/en/functions.html
Expressions can be used at several points in SQL statements, such as in the ORDER BY or HAVING clauses of SELECT statements, in the WHERE clause of a SELECT, DELETE, or UPDATE statement, or in SET statements. Expressions can be written using values ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-schema.html
For example, to view information about instrumented InnoDB file objects seen by the Performance Schema when executing file I/O instrumentation, you might issue the following query: mysql> SELECT * FROM performance_schema.file_instances WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
To execute RENAME TABLE, there must be no active transactions or tables locked with LOCK TABLES. If any errors occur during a RENAME TABLE, the statement fails and no changes are made. If a table has triggers, attempts to rename the table into a ...
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-example.html
Assume also that the MySQL server is under load at the time of the crash. Information about this recovery process is conveyed to the user through the MySQL error log. You should include such options as necessary to enable client programs to connect ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table-optimization.html
Set the variable to the maximum file size for your system, after checking to be sure that there is enough free space to hold a copy of the table files. REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management.html
If you (for example) wish to drop a partition and reorganize a table's remaining partitions, you must do so in two separate ALTER TABLE statements (one using DROP PARTITION and then a second one using REORGANIZE PARTITION). MySQL 5.7 provides a ...