Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...
https://dev.mysql.com/doc/refman/8.4/en/charset-database.html
For stored routines (procedures and functions), the database character set and collation in effect at routine creation time are used as the character set and collation of character data parameters for which the declaration includes no CHARACTER SET ... Every database has a database character set and a database ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
This helps the MySQL upgrade procedure detect and upgrade tables containing old temporal columns. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
Note Within all stored programs (stored procedures and functions, triggers, and events), the parser treats BEGIN [WORK] as the beginning of a BEGIN ... SET autocommit disables or enables the default autocommit mode for the current session. This ...
https://dev.mysql.com/doc/refman/8.4/en/conditions-and-parameters.html
If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propagated back to the caller. If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
When the thread stack is too small, this limits the complexity of the SQL statements the server can handle, the recursion depth of stored procedures, and other memory-consuming actions. This section describes aspects of how the MySQL server manages ...
https://dev.mysql.com/doc/refman/8.4/en/create-function.html
The CREATE FUNCTION statement is used to create stored functions and loadable functions: For information about creating stored functions, see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”. For information about creating ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE permits the following CHECK constraint syntax, for both table constraints and column constraints: [CONSTRAINT [symbol]] CHECK (expr) ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
Values of a generated column are computed from an expression included in the column definition. Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] ...
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
Note An easier alternative to generating the files required for SSL than the procedure described here is to let the server autogenerate them; see Section 8.3.3.1, “Creating SSL and RSA Certificates and Keys using MySQL”. This section describes ...