Search Results
https://dev.mysql.com/doc/refman/8.4/en/timestamp-lookups.html
In the preceding discussion, the data set stored in tstable happens to consist of distinct UTC values. If the index is not UNIQUE, it is possible for the table (and the index) to store multiple instances of a given UTC value. Temporal values are ...
https://dev.mysql.com/doc/refman/8.4/en/using-mysqldump.html
This output consists of CREATE statements to create dumped objects (databases, tables, stored routines, and so forth), and INSERT statements to load data into tables. With --tab, mysqldump produces two output files for each dumped table. The server ... Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and MySQL HeatWave compatibility checks and ...
https://dev.mysql.com/doc/refman/8.4/en/xa-restrictions.html
The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. This means that the same XA transaction can appear in the events_transactions_current ... XA transaction support is limited to the InnoDB storage ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-show-status.html
The Status column contains a description of the cluster's status; possible values and their meanings are shown in the following table: Table 5.1 Status values shown by show status --cluster Status Value Meaning fully operational All cluster ... show ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-codes.html
The following table shows the permissible values for the buffer_type member of MYSQL_BIND structures for input values sent to the server. The table shows the C variable types that you can use, the corresponding type codes, and the SQL data types for ... The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-api-components.html
SQL statements: INSTALL PLUGIN registers a plugin in the mysql.plugin table and loads the plugin code. UNINSTALL PLUGIN unregisters a plugin from the mysql.plugin table and unloads the plugin code. The mysql.plugin table lists each plugin that was ...The WITH PARSER clause for full-text index creation associates a full-text parser plugin with a given FULLTEXT ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-classification-overview.html
mysql> CREATE DATABASE classification_data; mysql> USE classification_data; Create the table to insert the sample data into. This topic describes how to prepare the data to use for a classification machine learning model. The classification ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-predictions-ml-predict-row.html
The column names must match the feature column names in the trained table. Generating Predictions on One or More Rows of Data Another way to generate predictions is to create a JSON_OBJECT with specified columns and labels, and then generate ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-data.html
Labeled Data Example A table of data for bank customers can be a labeled dataset. The feature columns in the table have data related to job, marital status, education, and city of residence. You can use some of the data in this table to train a ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-preparing-a-recommendation-model.html
mysql> CREATE DATABASE recommendation_data; mysql> USE recommendation_data; Create the table to insert the sample data into. mysql> CREATE TABLE training_dataset ( user_id VARCHAR(3), item_id VARCHAR(3), rating DECIMAL(3, 1), PRIMARY KEY (user_id, ... This topic describes how to prepare the data to use for a recommendation machine learning model using explicit ...