https://dev.mysql.com/creating-tables.html
Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); VARCHAR is a good choice for the name, owner, and species ...
https://dev.mysql.com/data-size.html
The compact family of row formats also optimizes CHAR column storage when using a variable-length character set such as utf8mb3 or utf8mb4. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. Many languages ... Design your tables to minimize their space on the ...
https://dev.mysql.com/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/features.html
This section describes some of the important characteristics of the MySQL Database Software. Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, ...In most respects, the roadmap applies to all versions of ...
https://dev.mysql.com/innodb-information-schema-system-tables.html
The FLAG field provides bit level information about table format and storage characteristics. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of ...
https://dev.mysql.com/innodb-memcached-internals.html
table_map_delimiter: The character separating the schema name and the table name when you use the @@ notation in a key name to access a key in a specific table. Multiple columns can be specified using the separator character specified in the ... The ...
https://dev.mysql.com/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the column (see Section 8.3.5, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the ...
https://dev.mysql.com/mysql-cluster-replication-conflict-resolution.html
When using a replication setup involving multiple masters (including circular replication), it is possible that different masters may try to update the same row on the slave with different data. Conflict resolution in NDB Cluster Replication ...
https://dev.mysql.com/mysql-library-init.html
int mysql_library_init(int argc, char **argv, char **groups) Call this function to initialize the MySQL client library before you call any other MySQL function. Note To avoid memory leaks after the application is done using the library (for ...
https://dev.mysql.com/mysql-list-fields.html
MYSQL_RES *mysql_list_fields(MYSQL *mysql, const char *table, const char *wild) Note mysql_list_fields() is deprecated and will be removed in a future version of MySQL. wild may contain the wildcard characters % or _, or may be a NULL pointer to ...
