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/information-schema-engines-table.html
In the latter case, the error log should contain a reason indicating why the option is disabled. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. The ENGINES table has these ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the database with which the routine is associated to execute the routine. If the automatic_sp_privileges system variable is 0, the EXECUTE ... The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return. Use of an unqualified * with other items in the select list may produce a parse error. The ...
https://dev.mysql.com/doc/refman/5.7/en/windows-and-ssh.html
Save everything; otherwise you must to redo it the next time. This section describes how to get an encrypted connection to a remote MySQL server with SSH. This userid value might not be the same as the user name of your MySQL account. Either do a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-index.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
Rewriting Prepared Statements Prepared statements are rewritten at parse time (that is, when they are prepared), not when they are executed later. If a rule cannot be loaded due to some error, calling flush_rewrite_rules() produces an error: mysql> ... To enable or disable the plugin, enable or disable the rewriter_enabled system ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found wrong password for user 'some_user'@'some_host'; ignoring user As ...
https://dev.mysql.com/doc/refman/5.7/en/myisampack.html
If you kill myisampack, the .TMD file might not be deleted.) Normally, myisampack exits with an error if it finds that tbl_name.TMD exists. When the table is used later, the server reads into memory the information needed to decompress columns. This ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
You want to use a column containing date or time values, or containing values arising from some other series. For example, when executing a query such as EXPLAIN SELECT COUNT(*) FROM employees WHERE separated BETWEEN '2000-01-01' AND '2000-12-31' ...
https://dev.mysql.com/doc/refman/5.7/en/prepare.html
The prepared statement is executed with EXECUTE and released with DEALLOCATE PREPARE. Within the statement, ? characters can be used as parameter markers to indicate where data values are to be bound to the query later when you execute it. This ...