Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...In the case of direct execution, the query is parsed every time it is ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...In the case of direct execution, the query is parsed every time it is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
SELECT statement, the SELECT query is offloaded to MySQL HeatWave for execution, and result is copied into the target table in the DB System. For example, the following statement inserts data into the flight_from_US table on the DB System, by ...
https://dev.mysql.com/doc/refman/8.4/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...DROP TABLE causes an implicit commit, except when used with the TEMPORARY ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
You can rename tables locked with a LOCK TABLES statement, provided that they are locked with a WRITE lock or are the product of renaming WRITE-locked tables from earlier steps in a multiple-table rename operation. If any errors occur during a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-if-not-exists.html
IF NOT EXISTS statements are replicated: Every CREATE DATABASE IF NOT EXISTS statement is replicated, whether or not the database already exists on the source. Similarly, every CREATE TABLE IF NOT EXISTS statement without a SELECT is replicated, ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. A similar statement, SHOW FUNCTION CODE, displays information about stored functions (see Section ...
https://dev.mysql.com/doc/refman/8.4/en/sys-host-summary-by-statement-latency.html
The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. total_latency The total wait time of timed statements for the host. max_latency The maximum single ...Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-latency.html
The user_summary_by_statement_latency and x$user_summary_by_statement_latency views have these columns: user The client user name. total_latency The total wait time of timed statements for the user. max_latency The maximum single wait time of timed ...Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of ...
https://dev.mysql.com/doc/refman/8.4/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...