Search Results
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to work without modification even if the table is altered to add a new column that the application ...
https://dev.mysql.com/doc/refman/8.4/en/telemetry-metrics-meter-metrics.html
open_streams Open_streams ASYNC COUNTER The number of streams that are open, used mainly for logging open_table_definitions Open_table_definitions ASYNC GAUGE COUNTER The number of cached table definitions open_tables Open_tables ASYNC GAUGE COUNTER ... The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno Metrics mysql.inno.buffer_pool Metrics mysql.inno.data Metrics mysql.x Metrics mysql.x.stmt Metrics The maximum number of metric instruments which can be created is set by ...
https://dev.mysql.com/doc/refman/8.4/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 ...For dependent subqueries in the select list, no data change statements are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/partial.html
There are various ways to create different kinds of partial backup with MySQL Enterprise Backup: Including or excluding specific tables by their names. Each table is checked against the regular expression specified with the --include-tables or ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.14.2, “Refresh Data Using Incremental Load”. This adds an include list to exactly specify the tables and columns to load for a set ...MySQL 8.4.0 adds support for the following: An input_list JSON array replaces the db_list JSON ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. They are actually views, not base tables, so there are no files ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-how-to-import-onnx.html
Import model as a string: For smaller models, you can copy the encoded string and paste it into a session variable or temporary table column. Import model directly from a table: For larger models, you can load the entire file into a table with the ... This topic describes how to import an external ONNX ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
(Selecting from the view selects, in effect, using the SELECT statement.) The select_statement can select from base tables or from other views. The SELECT statement can use a VALUES statement as its source, or can be replaced with a TABLE statement, ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
To write data from a table to an XML file, you can invoke the mysql client with the --xml and -e options from the system shell, as shown here: $> mysql --xml -e 'SELECT * FROM mydb.mytable' > file.xml To read the file back into a table, use LOAD XML. By default, the <row> element is considered to be the equivalent of a database table row; this can be changed using the ROWS IDENTIFIED BY ...