Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
ORDER BY is permitted in a view definition, but it is ignored if you select from a view using a statement that has its own ORDER BY. If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/8.4/en/disk-issues.html
Depending on how you set the striping parameters and number of disks, you may get differences measured in orders of magnitude. Data inconsistencies introduced due to messages received out of order or lost network traffic. This section describes ...
https://dev.mysql.com/doc/refman/8.4/en/distinct-optimization.html
DISTINCT combined with ORDER BY needs a temporary table in many cases. Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. In most cases, a DISTINCT clause ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
This is useful when you want to put data into ordered groups. You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
Moreover, distinguishing characters is not the same as ordering them per the conventions of a given CJK language. This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
This means that you should not chain two servers together in a two-way replication relationship unless you are sure that your updates can safely happen in any order, or unless you take care of mis-ordered updates somehow in the client code. In the ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
By default, triggers that have the same trigger event and action time activate in the order they were created. To affect trigger order, specify a clause after FOR EACH ROW that indicates FOLLOWS or PRECEDES and the name of an existing trigger that ...Where can I find the documentation for MySQL 8.4 triggers? ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise Firewall”. This section describes how to configure MySQL Enterprise Firewall using SQL ...