Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-fetch.html
int mysql_stmt_fetch(MYSQL_STMT *stmt) Description mysql_stmt_fetch() returns the next row in the result set. It can be called only while the result set exists; that is, after a call to mysql_stmt_execute() for a statement such as SELECT that ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-status-system-variables.html
The st_mysql_show_var structure has this definition: struct st_mysql_show_var { const char *name; char *value; enum enum_mysql_show_type type; }; The following table shows the permissible status variable type values and what the corresponding ...
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
Note Kerberos pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using Kerberos, ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-sets.html
The reason is that utf8mb4_unicode_ci supports mappings such as expansions; that is, when one character compares as equal to combinations of other characters. (See Section 14.8, “String Functions and Operators”.) If a collation uses a weight ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
Input File Character Set The file name must be given as a literal string. The server interprets the file name using the character set indicated by the character_set_filesystem system variable. By default, the server interprets the file contents ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
(See Section 17.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 ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
String Type Storage Requirements In the following table, M represents the declared column length in characters for nonbinary string types and bytes for binary string types. Data Type Storage Required CHAR(M) The compact family of InnoDB row formats ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
REAL FLOAT NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL SMALLMONEY DECIMAL CHAR CHAR/LONGTEXT Depending on its length. MySQL Server 5.6 and higher can have CHAR columns with a length up to 255 characters. MySQL Server 5.6 and higher can have ...
https://dev.mysql.com/doc/internals/en/creating-handlerton.html
The handlerton (short for handler singleton) defines the storage engine and contains method pointers to those methods that apply to the storage engine as a whole, as opposed to methods that work on a per-table basis. Some examples of such methods ...
https://dev.mysql.com/doc/internals/en/memory-allocation-library-or-storage-engine.html
For the simple case, use the functions in mysys/my_malloc.c: void *my_malloc(size_t size, myf my_flags); void *my_memdup(const void *from, size_t length, myf my_flags); char *my_strdup(const char *from, myf my_flags); char *my_strndup(const char ...