Search Results
https://dev.mysql.com/doc/refman/9.7/en/replace.html
| TABLE table_name} value: {expr | DEFAULT} value_list: value [, value] ... REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-myisam-fk.html
In this case, relationship lines between foreign keys in the table will automatically be drawn. This graphical representation makes the relationships between the tables much easier to understand. This means that MyISAM tables that are reverse ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
Possible values include: Iris Setosa Iris Versicolour Iris Virginica Data is stored in the MySQL database in the following schema and tables: ml_data schema: The schema containing training and test dataset tables. Prepare Datasets Create and use the ... This quickstart illustrates an end-to-end example of creating and using a predictive machine learning model using MySQL HeatWave ...
https://dev.mysql.com/doc/refman/9.7/en/plugin-loading.html
Built-in Plugins Plugins Registered in the mysql.plugin System Table Plugins Named with Command-Line Options Plugins Installed with the INSTALL PLUGIN Statement Built-in Plugins A built-in plugin is known by the server automatically. Plugins ...
https://dev.mysql.com/doc/refman/9.7/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.privileges.html
Here are the privileges required by mysqlbackup: The minimum privileges for the MySQL user with which mysqlbackup connects to the server include: SELECT on all databases and tables, for table locks that protect the backups against inconsistency ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-monitoring.html
You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and clone_progress Performance Schema tables. Note The clone_status and clone_progress Performance Schema tables can be used ...To monitor a cloning operation on the donor MySQL server instance, use the clone stage events, as described in Monitoring Cloning Operations Using Performance Schema Stage ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
This is an example of a minimal CREATE EVENT statement: CREATE EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE myschema.mytable SET mycol = mycol + 1; The previous statement creates an event named myevent. This event ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates-markers.html
Using the table The table shows which variables are defined in which sections. If a variable type is a variable, then the table describes its data dictionary, and a parent dictionary if type is a section. These markers can be used in any template, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
You can pass the text string in the routine manually or use data from tables in your database. To embed multiple rows of text stored in a table in a single run, you can even run a batch query. Using this method, you can create vector embedding ...