Search Results
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-automl-privileges.html
mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, DELETE, UPDATE ON database_name.* TO 'user_name'@'%'; Tracking and Monitoring Privileges You need the following privileges to track/monitor the status of AutoML and AutoML routines.. mysql> GRANT ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-a-forecasting-model.html
mysql> CREATE TABLE electricity_demand ( date DATE PRIMARY KEY, demand FLOAT NOT NULL, temperature FLOAT NOT NULL ); Insert the sample data into the table. This topic describes how to prepare the data to use for a forecasting machine learning model. To prepare the data for this use case, you set up a training dataset and a testing ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prepare-data-split.html
If the number of samples in the 80% subset is fewer than five, then five samples are inserted into the training dataset. You can automatically create training and testing datasets with the TRAIN_TEST_SPLIT routine. Overview The TRAIN_TEST_SPLIT ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-aiaml-error-messages.html
Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Each error message includes an error number, SQLSTATE value, and ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-management.html
The next figure shows an example that adds table locks, uses replace instead of insert statements, quotes identifiers with backtick characters, and so on. Use this wizard to either export or import SQL generated from MySQL Workbench or with the ...
https://dev.mysql.com/doc/workbench/en/wb-audit-inspector.html
MySQL Workbench offers a graphical interface to MySQL Enterprise Audit. To activate the audit_log plugin manually using mysql, load the plugin code from the library file at runtime with the INSTALL PLUGIN statement. On Windows: INSTALL PLUGIN ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling.html
Modeling simplifies database design and maintenance by enabling you, the data architect, to visualize requirements and resolve design issues. Model-driven database design is an efficient methodology for creating valid and well-performing databases, ...
https://dev.mysql.com/doc/workbench/en/wb-intro.html
The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views. This chapter provides general information about MySQL Workbench and how it has ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. SMALLINT SMALLINT BIGINT BIGINT ...