MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 151 to 158 of 158 total results

« Previous
14
15
16
Next »

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. An SqlResult is produced whenever a query is executed using sqlExecute.execute(), PreparedStatement.execute(), or Session.runSql(). Methods ...

14.8.1 String Comparison Functions and Operators

https://dev.mysql.com/doc/refman/9.7/en/string-comparison-functions.html

Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...

30.4.5.16 The ps_thread_stack() Function

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-thread-stack.html

Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID. The value should match the THREAD_ID column from some Performance Schema threads table row. row *************************** ...

30.4.4.24 The ps_truncate_all_tables() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-truncate-all-tables.html

Example mysql> CALL sys.ps_truncate_all_tables(FALSE); +---------------------+ | summary | +---------------------+ | Truncated 49 tables | +---------------------+ . Truncates all Performance Schema summary tables, resetting all aggregated ...

27.6.3 Updatable and Insertable Views

https://dev.mysql.com/doc/refman/9.7/en/view-updatability.html

Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...

8.4.1.11 WebAuthn Pluggable Authentication

https://dev.mysql.com/doc/refman/9.7/en/webauthn-pluggable-authentication.html

By default, the option is set to FALSE, indicating that assertions are to be created using all resident keys for a given RP ID. Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL ...

15.2.20 WITH (Common Table Expressions)

https://dev.mysql.com/doc/refman/9.7/en/with.html

The optimizer cannot predict the number of iterations because it cannot predict at what point the WHERE clause becomes false. A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and ...

5.3.4.6 Working with NULL Values

https://dev.mysql.com/doc/refman/9.7/en/working-with-null.html

In MySQL, 0 or NULL means false and anything else means true. The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. This special ...