Search Results
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
IF NOT EXISTS has no effect in such cases; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”. To correct this, use DROP FUNCTION to drop the loadable function and CREATE FUNCTION to re-create the loadable function with a ...
https://dev.mysql.com/doc/refman/8.4/en/metadata-locking.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 14.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
Deleting it puts all SQL nodes in read-only mode; NDB detects that this table has been dropped, and re-creates it, after which it is possible once again to perform updates. Dropping and re-creating ndb_apply_status creates a gap event in the binary ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and in the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-triggers.html
If triggers for the table are added or dropped subsequent to the downgrade, the server rewrites the table's .TRG file. If the trigger needs multiple result values from the code, you can put the code in a stored procedure and return the values using ... With statement-based replication, triggers executed on the source also execute on the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
Only statements involving tables are affected, not statements such as CREATE DATABASE, DROP DATABASE, and ALTER DATABASE. It does not apply to stored procedures and functions, or events. If the table name pattern is %, it matches any table name and ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup Options for Replica Servers System Variables Used on Replica Servers Specify the options either on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
There must be no tables or stored procedures with individual ENUM or SET column elements that exceed 255 characters or 1020 bytes in length. Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or ...
https://dev.mysql.com/doc/refman/8.4/en/user-names.html
You should never alter the structure of tables in the mysql database in any manner whatsoever except by means of the procedure that is described in Chapter 3, Upgrading MySQL. Thereafter, you normally set up, modify, and remove MySQL accounts using ... MySQL stores accounts in the user table of the mysql system ...
https://dev.mysql.com/doc/workbench/en/wb-creating-eer-diagram.html
You can add tables to the EER canvas by dragging them from the Catalog panel dropping them onto the canvas. Drop the address table and the city table onto the canvas, as the following figure shows. Drop the country table onto the canvas and ... To ...
https://dev.mysql.com/doc/workbench/en/wb-database-synchronization.html
Synchronizing models with objects that differ in case may lead to MySQL Workbench producing a DROP statement for that object, before recreating it as lowercase. Or a temporary workaround is to delete the DROP SCHEMA IF EXISTS line from the generated ...These three types can be the target (destination), source, or ...