Search Results
https://dev.mysql.com/doc/refman/9.7/en/values.html
The DEFAULT keyword is not supported by VALUES and causes a syntax error, except when it is used to supply values in an INSERT statement. You should also not confuse it with the VALUES() function that refers to column values in INSERT ... In place ... VALUES is a DML statement which returns a set of one or more rows as a ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-affected-rows.html
It returns the number of rows changed, deleted, or inserted by the last statement if it was an UPDATE, DELETE, or INSERT. For REPLACE statements, the affected-rows value is 2 if the new row replaced an old row, because in this case, one row was ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-0-0.html
This has been done for the following reasons: Ignoring such errors sometimes led to insertion of NULL into non-nullable columns (for untransformed subqueries), or of no row at all (subqueries using subquery_to_derived). For backward compatibility, ...It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-how-to-import-onnx.html
mysql> LOAD DATA INFILE 'iris_base64.onnx' INTO TABLE onnx_temp CHARACTER SET binary FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r' (onnx_string); Insert the loaded string into a session variable. Import model as a string: For smaller models, ...
https://dev.mysql.com/doc/refman/9.7/en/explain-output.html
For example, it appears for EXPLAIN INSERT INTO t VALUES(10) because that is equivalent to EXPLAIN INSERT INTO t SELECT 10 FROM DUAL. For INSERT or REPLACE statements, EXPLAIN displays this value when there is no SELECT part. This can also indicate ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-performance-midpoint_insertion.html
Newly read blocks are inserted into the middle of the LRU list. This arrangement divides the LRU list into two segments, where the pages downstream of the insertion point are considered “old” and are desirable victims for LRU eviction. You can ... Rather than using a strict LRU algorithm, InnoDB uses a technique to minimize the amount of data that is brought into the buffer pool and never accessed ...The goal is to make sure that frequently ...
https://dev.mysql.com/doc/refman/9.7/en/session-state-tracking.html
(To change sessions in a load-balanced environment, it is necessary to detect whether there is session state to take into consideration when deciding whether a switch can be made.) The tracker mechanism permits applications to know when transactions ...A client can enable these trackers to receive notification of changes to its session ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-audit-plugins.html
It also sets null_audit_event_order_check to EVENT-ORDER-ABORT: mysql> INSERT INTO db1.t1 VALUES ('some data'); ERROR 3164 (HY000): Aborted by Audit API ('MYSQL_AUDIT_QUERY_STATUS_END';1). A nonzero return value is not taken into consideration and ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...
https://dev.mysql.com/doc/workbench/en/wbcopytables.html
The copy executes a SELECT statement on the source database and then INSERT to insert the retrieved rows into the target MySQL server. Full Table Copy This argument performs a full SELECT on the source table, fetches records, and then inserts them ...Caution Use caution as this expression is copied directly into the source SELECT ... wbcopytables is a command-line utility included in MySQL Workbench ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
This tutorial teaches you how to use the MySqlScript class. Depending on the circumstances, this can be more convenient than using the MySqlCommand approach. Further details of the MySqlScript class can be found in the reference documentation ...