Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/9.7/en/datetime.html
In particular, any fractional part in a value inserted into a DATETIME or TIMESTAMP column is stored rather than discarded. You can specify a time zone offset when inserting a TIMESTAMP or DATETIME value into a table. This section describes their ...
https://dev.mysql.com/doc/refman/9.7/en/encryption-functions.html
For example: INSERT INTO t VALUES (1,AES_ENCRYPT('text',UNHEX('F3229A0B371ED2D9441B830D21A390C3'))); A passphrase can be used to generate an AES key by hashing the passphrase. For example: INSERT INTO t VALUES (1,AES_ENCRYPT('text', UNHEX(SHA2('My ...If you want to store these results, use a column with a VARBINARY or BLOB binary string data ...