PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-column.html
isNumberSigned(): Indicates whether a numeric column is signed (true if it is signed). The Column object represents the column metadata in a result set. Column has the methods listed here: getFractionalDigits(): Gets the fractional digits of the ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-sqlresult.html
hasData(): Returns true if the most recently executed statement yielded a result set, false otherwise. Returns true if the result set is available and contains data. An SqlResult is produced whenever a query is executed using sqlExecute.execute(), ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-table.html
The Table object represents a database table existsInDatabase(): Returns true if the table exists in the current database, otherwise false. isView(): Returns true if the table is a view, otherwise false. count(): Returns the number of rows in this ...
https://dev.mysql.com/doc/refman/9.7/en/string-comparison-functions.html
The same is true for aggregate queries involving NULL and comparisons using NOT RLIKE or NOT REGEXP. Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-optimization-with-exists.html
The “pushdown” strategy just described works if either of these conditions is true: outer_expr and inner_expr cannot be NULL. AND trigcond(oe_N=ie_N) ) Each trigcond(X) is a special function that evaluates to the following values: X when the ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-trace-statement-digest.html
Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. This section describes the syntax for account names, including special ...
https://dev.mysql.com/doc/refman/9.7/en/alter-event.html
This is true for both ALTER EVENT and CREATE EVENT statements. The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE EVENT. (See Section 15.1.15, ...