Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/processing-warnings.html
Similar to the execution of single statements committing or rolling back a transaction can also trigger warnings. To be able to process these warnings the replied result object of Session.commit(); or Session.rollback(); needs to be checked. The ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-copy-mysql-configuration.html
Initialization variables: Set preferred values for (and only for) any initialization variables whose values you want to be different from the base configuration you are copying: Click Select a variable name, and select the variable from the ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-create-mysql-configuration.html
Click Select a variable name, and select the variable from the drop-down list. Click Select a value, and select the value from the drop-down list, or enter the preferred value. Click Select a variable name, and select the variable from the drop-down ... Creating a MySQL Configuration 19.1 Creating a MySQL Configuration Use the MySQL HeatWave Console to create a new MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
Without the system user concept, a user who has the CREATE USER privilege can modify or drop any existing account, including the root account. Regular users with the CREATE USER privilege can still modify or drop existing accounts, but only regular ... MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
If you drop an AUTO_INCREMENT column and then add another AUTO_INCREMENT column, the numbers are resequenced beginning with 1. Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step is to drop ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
Partitioned Table Support DELETE supports explicit partition selection using the PARTITION clause, which takes a list of the comma-separated names of one or more partitions or subpartitions (or both) from which to select rows to be dropped. Given a ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
To remove them, use the DROP FUNCTION statement: DROP FUNCTION service_get_read_locks; DROP FUNCTION service_get_write_locks; DROP FUNCTION service_release_locks; Using the Locking Service Function Interface Before using the locking service ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
You should not use ANALYZE TABLE, REPAIR TABLE, OPTIMIZE TABLE, ALTER TABLE, DROP TABLE, DELETE without a WHERE clause, or TRUNCATE TABLE on any of the tables that are mapped into an open MERGE table. DROP TABLE on a table that is in use by a MERGE ... The following are known problems with MERGE tables: MERGE child tables are locked through the parent ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
To reverse-engineer a database using a create script, do one of the following: On the home screen, select the model view from the sidebar, click (>) next to Models, and then click Reverse Engineer MySQL Create Script. If your script creates a ...
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
Database , Initial Catalog Default: mysql The case-sensitive name of the database to use initially. // Connection string example var conn = new MySqlConnection("server=_mysql._tcp.example.abc.com.; dns-srv=true; user id=user; password=****; ... This ...