Search Results
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
mysql_tzinfo_to_sql This program loads the time zone tables in the mysql database using the contents of the host system zoneinfo database (the set of files describing time zones). mysqladmin A client that performs administrative operations, such as ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
(Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based logging or replication. (Bug #11754117, Bug #45670) This ... Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. This statement requires some privilege for any column in the table. row *************************** Table: ...The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.usage.html
Table 20.1 List of All Options Option Name Description --backup-dir The directory to store the backup data. --backup_innodb_data_file_path Specifies Innodb system tablespace files' path and size in backup. --backup_innodb_data_home_dir Backup base ... The following sections describe the command-line options for the different modes of operation of ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/trouble.logging.html
Besides the message output of MySQL Enterprise Backup to the stderr stream and the log file, progress and history of each backup are also logged into the mysql.backup_progress and mysql.backup_history tables on the backed-up servers (to skip ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-missing.html
To cause MySQL NDB Cluster data to be distributed to any such excluded or skipped nodes following a partial restore, it is necessary to redistribute the data manually by executing an ALTER ONLINE TABLE ... REORGANIZE PARTITION statement in the mysql ... It is possible using MySQL Cluster Manager to perform a partial restore of a MySQL NDB Cluster—that is, to restore from a backup in which backup images from one or more data nodes are not ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-session-track-get-first.html
If any characteristics apply that cannot be passed to START TRANSACTION, such as ISOLATION LEVEL, a suitable SET TRANSACTION statement is prepended (for example, SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; START TRANSACTION READ WRITE;). If a ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-a-forecasting-model.html
Therefore, the predict table must not overlap the datetime_index with the training table. The start date in the predict table must be a date immediately following the last date in the training table when exogenous_variables are used. For example, ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-rag.html
vector_store: the list of vector store tables used for context retrieval. It can include the following parameters: vector_store: specifies a list of loaded vector store tables to use for context retrieval. By default, the routine performs a global ... The ML_RAG routine performs retrieval-augmented generation (RAG) by: Taking a natural-language ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-vb.html
5.6.7.1.1 ADO: rs.addNew, rs.delete, and rs.update The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = ...