Search Results
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.
https://dev.mysql.com/doc/connector-j/en/connector-j-schema-validation.html
When working with MySQL Server 8.0.19 and later: Schema validation can be configured for a Collection, so that documents in the Collection are validated against a schema before they can be inserted or updated. Attempting to insert or modify a ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
For MyISAM tables, you can set the first sequence number by executing SET INSERT_ID=value before ALTER TABLE or by using the AUTO_INCREMENT=value table option. This occurs because the order in which the rows are numbered depends on the specific ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). For SQL output (CREATE and INSERT statements), local or remote dumps can ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values ...
https://dev.mysql.com/doc/refman/8.4/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf32.html
For example, this is illegal: INSERT INTO t (utf32_column) VALUES (0x110000); /* illegal */ . The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
This can be a simple statement such as SELECT or INSERT, or a compound statement written using BEGIN and END. MODIFIES SQL DATA indicates that the routine contains statements that may write data (for example, INSERT or DELETE). By default, a stored ...