Search Results
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
Despite differences in storage layout on disk, the internal MySQL APIs that communicate and exchange information about table rows use a consistent data structure that applies across all storage engines. This section includes guidelines and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-usage.html
For example, to examine the definitions of the session view and format_bytes() function, use these statements: mysql> SHOW CREATE VIEW sys.session; mysql> SHOW CREATE FUNCTION sys.format_bytes; However, those statements display the definitions in ...
https://dev.mysql.com/doc/refman/8.4/en/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
A value can be a literal of any MySQL data type or an expression that resolves to a scalar value. VALUES is a DML statement which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as ...
https://dev.mysql.com/doc/refman/8.4/en/xa.html
The MySQL XA implementation is based on the X/Open CAE document Distributed Transaction Processing: The XA Specification. The XA interface to a MySQL server consists of SQL statements that begin with the XA keyword. MySQL client programs must be ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/crd-ndbclusterspec.html
managementNode (NdbManagementNodeSpec): (optional) Specifies the configuration of the management node running in MySQL Cluster. mysqlNode (NdbMysqldSpec): (optional) Specification for any MySQL Servers run as NDB Cluster SQL nodes. NDB Operator ...
https://dev.mysql.com/doc/ndb-operator/8.4/en/introduction.html
MySQL NDB Cluster, the distributed version of MySQL, is implemented as a collection of processes or nodes of the following three types: Management nodes (ndb_mgmd): Provision of configuration data Data nodes (ndbmtd): User data storage SQL nodes ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
To prepare the data for the semi-supervised anomaly detection model: Connect to the MySQL Server. mysql> CREATE DATABASE anomaly_data; mysql> USE anomaly_data; Create the table to insert the sample data into. mysql> CREATE TABLE credit_card_train ( ... This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly detection model, and an unsupervised anomaly detection model for ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-predict-table.html
mysql> CALL sys.ML_PREDICT_TABLE('census_data.census_train', @census_model, 'census_data.census_train_predictions', NULL); To view ML_PREDICT_TABLE results, query the output table. mysql> CALL ... ML_PREDICT_TABLE generates predictions for an entire ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. MySQL Server 5.6 and higher can have CHAR columns with a length up to 255 ...BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL ...