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/show-errors.html
The LIMIT clause has the same syntax as for the SELECT statement. You can also retrieve this number from the error_count variable: SHOW COUNT(*) ERRORS; SELECT @@error_count; SHOW ERRORS and error_count apply only to errors, not warnings or notes.
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
db The default database for the thread, or NULL if none has been selected. For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the Info value shows the SELECT statement. SHOW [FULL] PROCESSLIST The ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, “Extensions to SHOW Statements”. In such cases, use SELECT COUNT(*) to obtain an accurate count. A more accurate method of obtaining this ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/show-variables.html
A WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, “Extensions to SHOW Statements”. For variables with very long values that are not completely displayed, use SELECT as a workaround. For ...
https://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
-DINSTALL_LAYOUT=name Select a predefined installation layout: STANDALONE: Same layout as used for .tar.gz and .zip packages. You can select a predefined layout but modify individual component installation locations by specifying other options. The ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...
https://dev.mysql.com/doc/refman/5.7/en/sys-list-add.html
Example mysql> SELECT @@sql_mode; +----------------------------------------+ | @@sql_mode | +----------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES | +----------------------------------------+ mysql> SET @@sql_mode = ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-stack.html
row *************************** thread_stack: {"rankdir": "LR","nodesep": "0.10", "stack_created": "2014-02-19 13:39:03", "mysql_version": "5.7.3-m13", "mysql_user": "root@localhost","events": [{"nesting_event_id": "0", "event_id": "10", ... Returns ...
https://dev.mysql.com/doc/refman/5.7/en/sys-quote-identifier.html
Example mysql> SELECT sys.quote_identifier('plain'); +-------------------------------+ | sys.quote_identifier('plain') | +-------------------------------+ | `plain` | +-------------------------------+ mysql> SELECT sys.quote_identifier('trick`ier'); ... Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL ...