Search Results
https://dev.mysql.com/doc/refman/8.4/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as identifiers. Internally, identifiers are converted to and are stored as ...Section 11.2.1, “Identifier Length Limits”, indicates the maximum length of each type of ...
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
Internal Versus External Credentials Storage Some authentication plugins store account credentials internally to MySQL, in the mysql.user system table: caching_sha2_password mysql_native_password (deprecated) sha256_password (deprecated) Most ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
A statement prepared in stored program context cannot refer to stored procedure or function parameters or local variables because they go out of scope when the program ends and would be unavailable were the statement to be executed later outside the ...A prepared statement created within a stored program continues to exist after the program finishes executing and can be executed outside the program ...
https://dev.mysql.com/doc/refman/8.4/en/replication-binlog-encryption-encryption-keys.html
A server instance only creates and removes keys generated for itself, but it can read keys generated for other instances if they are stored in the keyring, as in the case of a server instance that has been cloned by file copying. The sequence number ... The binary log encryption keys used to encrypt the file passwords for the log files are 256-bit keys that are generated specifically for each MySQL server instance using MySQL Server's keyring service (see Section 8.4.4, “The MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-drop-if-exists.html
IF EXISTS statements for stored programs (stored procedures and functions, triggers, and events) are also replicated, even if the stored program to be dropped does not exist on the source. The DROP DATABASE IF EXISTS, DROP TABLE IF EXISTS, and DROP ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-4.html
Firewall Notes In some cases, after performing an upgrade, stored procedures relating to MySQL Enterprise Firewall were not processed correctly. InnoDB: Virtual column information for a row containing an externally stored BLOB was not always logged ... Account Management Notes C API Notes Character Set Support Compilation Notes Component Notes Firewall Notes Installation Notes Optimizer Notes Performance Schema Notes Functionality Added or Changed Bugs Fixed Account Management Notes The database cache was not flushed properly following execution of DROP ...
https://dev.mysql.com/doc/workbench/en/wb-routines-routine-groups.html
MySQL Workbench unifies both stored procedures and stored functions into one logical object called a Routine. You can add Routine Groups to a database either from the Physical Schemata section of the MySQL Model page or from an EER Diagram.
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
A new auto-completion engine was added for use with object editors (triggers, views, stored procedures, and functions) in the visual SQL editor and in models. Important Some users with existing stored passwords will be prompted to enter a password ... This section summarizes how the MySQL Workbench 8.0 release series progressed with each minor ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-mysqlclient.html
MySqlScript Provides a class capable of executing an SQL script containing multiple SQL statements including CREATE PROCEDURE statements that require changing the delimiter. MySQLGuidFormat Specifies the stored type for a MySQL GUID data type.
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-sql-command.html
The procedure for performing an ExecuteNonQuery method call is simpler, as there is no need to create an object to store results. Again, this is straightforward, as a MySqlDataReader object is not required to store results, a variable is used ...