https://dev.mysql.com/sys-table-exists.html
in_db VARCHAR(64): The name of the database in which to check for table existance. in_table VARCHAR(64): The name of the table to check the existance of. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a ...
https://dev.mysql.com/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...
https://dev.mysql.com/audit-log-installation.html
This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related components described in Section 6.4.5.1, “Audit Log Components”. For general information about installing ...
https://dev.mysql.com/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Benefits ...
https://dev.mysql.com/c-api-prepared-statement-type-conversions.html
This enables you to distinguish BINARY from CHAR, VARBINARY from VARCHAR, and the BLOB types from the TEXT types. Prepared statements transmit data between the client and server using C language variables on the client side that correspond to SQL ...
https://dev.mysql.com/cache-index.html
| tbl_name PARTITION (partition_list) } IN key_cache_name tbl_index_list: tbl_name [{INDEX|KEY} (index_name[, index_name] ...)] partition_list: { partition_name[, partition_name] ... | ALL } The CACHE INDEX statement assigns table indexes to a ...
https://dev.mysql.com/call.html
CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE PROCEDURE. Stored procedures that take no arguments can be invoked without parentheses. CALL can pass back values ...
https://dev.mysql.com/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic ...
https://dev.mysql.com/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 characters in the Unicode range U+0000 to U+007F.
https://dev.mysql.com/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 ...
