Search Results
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version Tokens”. A scenario in which Version Tokens can be useful is a system that accesses a collection of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. Use of database symlinks on Windows is ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. The following discussion describes how to write ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-files-backed-up-innodb.html
If you use the compressed backup feature, the .ibd files are renamed in their compressed form to .ibz files. The backed-up files, as they are originally copied, form a raw backup that requires further processing. The apply step (either as part of a ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-cluster-setup-creating.html
In this section, we discuss the procedure for using MySQL Cluster Manager to create and start a new MySQL NDB Cluster. We assume that you have already obtained the MySQL Cluster Manager and MySQL NDB Cluster software, and that you are already ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-create-configure.html
Once this is done, we modify the target cluster's configuration until it matches that of the wild cluster that we want to import. At a later point in the example, we also show how to test the configuration in a dry run before attempting to perform ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options.html
int mysql_options(MYSQL *mysql, enum mysql_option option, const void *arg) Description Can be used to set extra connect options and affect behavior for a connection. This function may be called multiple times to set several options. The option ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options4.html
int mysql_options4(MYSQL *mysql, enum mysql_option option, const void *arg1, const void *arg2) Description mysql_options4() is similar to mysql_options() but has an extra fourth argument so that two values can be passed for the option specified in ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-attr-get.html
bool mysql_stmt_attr_get(MYSQL_STMT *stmt, enum enum_stmt_attr_type option, void *arg) Description Can be used to get the current value for a statement attribute. The option argument is the option that you want to get; the arg should point to a ...