Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
Definer The account of the user who created the trigger, in 'user_name'@'host_name' format. row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-files.html
InnoDB user-created temporary tables and on-disk internal temporary tables are created in a temporary tablespace file named ibtmp1 in the MySQL data directory. For some statements, MySQL creates temporary SQL tables that are not hidden and have ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/global-error-reference.html
Error number: 36; Symbol: EE_FAILED_TO_CREATE_TIMER; Message: Failed to create timer (OS errno %d). Error number: 38; Symbol: EE_FAILED_TO_CREATE_TIMER_QUEUE; Message: Failed to create timer queue (OS errno %d). Error number: 40; Symbol: ... This ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-extension-objects-examples.html
Example 11.1 Creating and Registering Extension Objects - Python This example creates a function hello_world() which is made available through the user-defined MySQL Shell global object demo. The code creates a new extension object and adds the ...
https://dev.mysql.com/doc/workbench/en/wb-vertical-toolbar.html
Change to the standard mouse pointer tool and pick up any objects you would like to place on the newly created layer. For more information about text objects, see Section 9.1.9, “Creating Text Objects”. 9.1.2.2.7 The Table Tool Use this tool to ... The vertical toolbar appears on the left sidebar (see the following figure) when an EER diagram tab is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
CREATE TABLE Statement Depending on the version of MySQL you are using, use the appropriate CREATE TABLE statement. As of MySQL 9.4.0, you can use the CREATE EXTERNAL TABLE statement, which automatically sets ENGINE to lakehouse, and ... To load ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-partition-operations.html
This clause always begins with PARTITION BY, and follows the same syntax and other rules as apply to the partition_options clause for CREATE TABLE (for more detailed information, see Section 15.1.20, “CREATE TABLE Statement”), and can also be ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.4. When you convert MyISAM tables that are large, frequently accessed, and hold vital data, investigate and consider the innodb_file_per_table and ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-partitioning-keys-unique-keys.html
This section discusses the relationship of partitioning keys with primary keys and unique keys. The rule governing this relationship can be expressed as follows: All columns used in the partitioning expression for a partitioned table must be part ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
A column's default value is determined by a number of factors, including its type, whether it is defined with a DEFAULT option, whether it is declared as NULL, and the server SQL mode in effect at the time of its creation; for more information, see ... Source and target tables for replication do not have to be ...