Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-catalog.html
The MODEL_CATALOG table is created in a schema named ML_SCHEMA_user_name, where the user_name is the name of the owning user. The fully qualified name of the model catalog table is ML_SCHEMA_user_name.MODEL_CATALOG. When a user creates a model, the ...AutoML creates a model catalog for any user that creates a machine learning ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-models-delete.html
Users that create models or have the required privileges to a model on the MODEL_CATALOG table can delete them. Delete a Model To delete a model from the model catalog table: Query the model catalog table for the model_id, model_owner, and ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-a-forecasting-model.html
mysql> CREATE DATABASE forecasting_data; mysql> USE forecasting_data; Create the table that is the sample dataset. mysql> CREATE TABLE electricity_demand ( date DATE PRIMARY KEY, demand FLOAT NOT NULL, temperature FLOAT NOT NULL ); Insert the sample ... This topic describes how to prepare the data to use for a forecasting machine learning ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-data-sets.html
Data items can be read from the database using Collection.find(), Table.select() and Session.sql(). Collection.find() returns a data set with documents and Table.select() respectively Session.sql() return a data set with rows. var myColl = ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode.html
MySQL 8.4 also displays utf8mb3 in place of utf8 in the columns of Information Schema tables, and in the output of SQL SHOW statements. Table 12.2, “Unicode Character Set General Characteristics”, summarizes the general characteristics of ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
CATALOG_NAME, SCHEMA_NAME, TABLE_NAME, COLUMN_NAME: Strings that indicate the catalog, schema, table, and column related to the condition. SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a ...
https://dev.mysql.com/doc/refman/8.4/en/innochecksum.html
This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged pages. It was originally developed to speed up verifying the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-rolling-restart.html
To free memory previously allocated to a table by successive INSERT and DELETE operations, for re-use by other NDB Cluster tables. Other parameters require that the data node be stopped completely using the management client STOP command, then ...
https://dev.mysql.com/doc/refman/8.4/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-bulk-loader.html
First an empty table needs to be created, in this case in the test database. CREATE TABLE Career ( Name VARCHAR(100) NOT NULL, Age INTEGER, Profession VARCHAR(200) ); A simple tab-delimited data file is also created (it could use any other field ...