Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-procedure.html
However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE. By default, that privilege is granted ... ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-roll-back.html
In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines. If you issue a statement early in a transaction that cannot be rolled ...
https://dev.mysql.com/doc/refman/8.4/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing ...
https://dev.mysql.com/doc/refman/8.4/en/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); Both the UNICODE attribute and the ucs2 character set are deprecated; you should expect them to be ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
With FOR UPGRADE, the server checks each table to determine whether there have been any incompatible changes in any of the table's data types or indexes since the table was created. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED ...
https://dev.mysql.com/doc/refman/8.4/en/compilation-problems.html
Normally, the build process does not need to create sql_yacc.cc because MySQL comes with a pregenerated copy. However, if you do need to re-create it, you might encounter this error: "sql_yacc.yy", line xxx fatal: default action causes potential...
https://dev.mysql.com/doc/refman/8.4/en/concurrent-inserts.html
If you are using the binary log, concurrent inserts are converted to normal inserts for CREATE ... This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup operation. If there are multiple INSERT ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
This section describes the functions that can be used to manipulate temporal values. See Section 13.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...