Search Results
https://dev.mysql.com/doc/refman/8.4/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column and line terminators can be specified to produce a specific output format. INTO DUMPFILE writes a single row to a file without any ...
https://dev.mysql.com/doc/refman/8.4/en/string-comparison-functions.html
Note Aggregate queries involving NOT LIKE comparisons with columns containing NULL may yield unexpected results. The same is true for aggregate queries involving NULL and comparisons using NOT RLIKE or NOT REGEXP. Table 14.13 String Comparison ...
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
We say that the subquery is nested within the outer query, and in fact it is possible to nest subqueries within other subqueries, to a considerable depth. The main advantages of subqueries are: They allow queries that are structured so that it is ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
MySQL does not support LIMIT in subqueries for certain subquery operators: mysql> SELECT * FROM t1 WHERE s1 IN (SELECT s2 FROM t2 ORDER BY s1 LIMIT 1); ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' ... In general, you cannot modify a table and select from the same table in a ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
However, in most cases there are corresponding INFORMATION_SCHEMA tables that can be queried. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
opened_tables Opened_tables ASYNC COUNTER The number of tables that have been opened prepared_stmt_count Prepared_stmt_count ASYNC GAUGE COUNTER The current number of prepared statements queries Queries ASYNC COUNTER The number of statements ... The ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
(ROLLBACK to SAVEPOINT is permitted because it does not end a transaction.). To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-asynchronous-interface-usage.html
This section describes how to use the C API asynchronous interface. In this discussion, asynchronous and nonblocking are used as synonyms, as are synchronous and blocking. The asynchronous C API functions cover operations that might otherwise block ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-basic-interface-usage.html
For SELECT queries, you retrieve the selected rows as a result set. Application programs should use this general outline for interacting with MySQL by means of the client library: Initialize the MySQL client library by calling mysql_library_init().