MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 131 to 139 of 139 total results

« Previous
12
13
14
Next »

https://dev.mysql.com/doc/refman/8.0/en/row-subqueries.html

If the t2 row col3 and col4 values are not equal the col1 and col2 values of any t1 row, the expression is FALSE and the query returns an empty result set. Scalar or column subqueries return a single value or a column of values. A row subquery is a ...

2.7 Installing MySQL on Solaris

https://dev.mysql.com/doc/refman/8.0/en/solaris-installation.html

Note MySQL 8.0 supports Solaris 11.4 and higher MySQL on Solaris is available in a number of different formats. For information on installing using the native Solaris PKG format, see Section 2.7.1, “Installing MySQL on Solaris Using a Solaris ...

14.8.1 String Comparison Functions and Operators

https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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 ...

3.5 Changes in MySQL 8.0

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL installation and applications. Changes marked as Incompatible change are incompatibilities with earlier versions of ...

27.5.3 Updatable and Insertable Views

https://dev.mysql.com/doc/refman/8.0/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 ...

15.2.20 WITH (Common Table Expressions)

https://dev.mysql.com/doc/refman/8.0/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/8.0/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 ...