https://dev.mysql.com/mysql-indexes.html
Characteristics specific to hash indexes (as used in MEMORY tables) are described in Section 8.3.9, “Comparison of B-Tree and Hash Indexes”. In this context, VARCHAR and CHAR are considered the same if they are declared as the same size. For ...
https://dev.mysql.com/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) This function creates a legal SQL string for use in an SQL statement. In this case, the function cannot escape quote characters except by ...Note ...
https://dev.mysql.com/mysql-session-track-get-first.html
int mysql_session_track_get_first(MYSQL *mysql, enum enum_session_state_type type, const char **data, size_t *length) MySQL implements a session tracker mechanism whereby the server returns information about session state changes to clients. (Of ...
https://dev.mysql.com/mysql-shell-tutorial-javascript-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. Examples in this section use the city table in ...
https://dev.mysql.com/mysql-shell-tutorial-python-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. Examples in this section use the city table in ...
https://dev.mysql.com/mysqlbinlog-row-events.html
Character set information is not available in the binary log, which affects string column display: There is no distinction made between corresponding binary and nonbinary string types (BINARY and CHAR, VARBINARY and VARCHAR, BLOB and TEXT). For ...
https://dev.mysql.com/mysqldump-delimited-text.html
--fields-enclosed-by=char The character within which to enclose column values (default: no character). --fields-optionally-enclosed-by=char The character within which to enclose non-numeric column values (default: no character). But this character ... This section describes how to use mysqldump to create delimited-text dump ...
https://dev.mysql.com/mysqldump.html
These may be used when dumping stored programs to preserve their character encodings. Note A dump made using PowerShell on Windows with output redirection creates a file that has UTF-16 encoding: shell> mysqldump [options] > dump.sql However, UTF-16 ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/mysqlslap.html
(That is, the implicit statement delimiter is the newline character.) Use the --delimiter option to specify a different delimiter, which enables you to specify statements that span multiple lines or place multiple statements on a single line.
https://dev.mysql.com/optimizing-innodb-storage-layout.html
(See Section 15.6.2.1, “Clustered and Secondary Indexes”.) Create an AUTO_INCREMENT column as the primary key if your primary key is long, or index a prefix of a long VARCHAR column instead of the entire column. Use the VARCHAR data type instead ... Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted ...
