Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
(The BLOB_FLAG and TIMESTAMP_FLAG flags are unneeded.) ENUM and SET values are returned as strings. For these, check that the type value is MYSQL_TYPE_STRING and that the ENUM_FLAG or SET_FLAG flag is set in the flags value. Pass the type value to ... This section describes C API data structures other than those used for prepared statements, the asynchronous interface, or the replication stream ...
https://dev.mysql.com/doc/ndbapi/en/mgm-structures.html
This section provides information about the data structures defined by the MGM API. The ndb_logevent Structure The ndb_mgm_node_state Structure The ndb_mgm_node_state2 Structure The ndb_mgm_cluster_state Structure The ndb_mgm_cluster_state2 ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
row *************************** Table: shirt Create Table: CREATE TABLE `shirt` ( `id` smallint(5) unsigned NOT NULL auto_increment, `style` enum('t-shirt','polo','dress') NOT NULL, `color` enum('red','blue','orange','white','black') NOT NULL, ...
https://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html
Trailing spaces are automatically deleted from ENUM and SET member values when the table is created. For the ENUM and SET data types, this does not occur; they are created as declared. In some cases, MySQL silently changes column specifications ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
There must be no tables or stored procedures with individual ENUM or SET column elements that exceed 255 characters or 1020 bytes in length. Prior to MySQL 8.4, the maximum combined length of ENUM or SET column elements was 64K. In MySQL 8.4, the ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 3503; Symbol: ER_NO_SUCH_DB; SQLSTATE: 42Y07 Message: Database '%s' doesn't exist Error number: 3504; Symbol: ER_TOO_BIG_ENUM; SQLSTATE: HY000 Message: Too many enumeration values for column %s. Error number: 3505; Symbol: ... The ...
https://dev.mysql.com/doc/workbench/en/wb-table-editor-columns-tab.html
Caution Care must be taken when entering a default value for ENUM columns because a non-numeric default will not be automatically quoted. For example, if the model is reverse engineered, the script will contain unquoted default values for ENUM ...
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/guided-tour-skeleton.html
Walking Through The Server Code: /sql/sql_parse.cc bool dispatch_command(enum enum_server_command command, THD *thd, char* packet, uint packet_length) { switch (command) { case COM_INIT_DB: ... Walking Through The Server Code: /sql/sql_parse.cc bool ... And now we're going to walk through something harder, namely the ...
https://dev.mysql.com/doc/internals/en/implementing-basic-table-scanning.html
Such engines might be used to support SQL queries of logs and other data files that are populated outside of MySQL. The implementation of the methods in this section provide the first steps toward the creation of more advanced storage engines.