https://dev.mysql.com/replication-features-differing-tables.html
ALL_SIGNED,ALL_UNSIGNED Treat promoted integer types as signed if possible, otherwise as unsigned. ALL_SIGNED tells the slave to treat all promoted integer types as signed; ALL_UNSIGNED instructs it to treat these as unsigned. Specifying both causes ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/numeric-type-attributes.html
An unsigned type can be used to permit only nonnegative numbers in a column or when you need a larger upper numeric range for the column. For example, if an INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift ... MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the ...
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. Because mysql_real_escape_string() returns an unsigned value, you can check ...Note mysql_real_escape_string() fails and produces an CR_INSECURE_API_ERR error if the NO_BACKSLASH_ESCAPES SQL mode is ...
https://dev.mysql.com/mysql-cluster-programs-ndb-config.html
Deprecated parameters are indicated in the XML output by the deprecated attribute, as shown here: <param name="NoOfDiskPagesToDiskAfterRestartACC" comment="DiskCheckpointSpeed" type="unsigned" default="20" min="1" max="4294967039" ... This tool ...
https://dev.mysql.com/mysql-stmt-attr-set.html
STMT_ATTR_CURSOR_TYPE unsigned long * Type of cursor to open for statement when mysql_stmt_execute() is invoked. STMT_ATTR_PREFETCH_ROWS unsigned long * Number of rows to fetch from server at a time when using a cursor. *arg can be in the range from ... bool mysql_stmt_attr_set(MYSQL_STMT *stmt, enum enum_stmt_attr_type option, const void *arg) Can be used to affect behavior for a prepared ...
https://dev.mysql.com/mysql-cluster-sci-definition.html
Host1SciId0 Table 22.322 This table provides type and value information for the Host1SciId0 SCI configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units unsigned Default [none] Range 0 - 4294967039 (0xFFFFFEFF) Restart Type ... [sci] sections in the config.ini file explicitly define SCI (Scalable Coherent Interface) connections between cluster ...
https://dev.mysql.com/example-foreign-keys.html
In MySQL, InnoDB tables support checking of foreign key constraints. See Chapter 15, The InnoDB Storage Engine, and Section 1.8.2.3, “Foreign Key Differences”. A foreign key constraint is not required merely to join two tables. It is extremely ...
https://dev.mysql.com/mysql-fetch-lengths.html
unsigned long *mysql_fetch_lengths(MYSQL_RES *result) Returns the lengths of the columns of the current row within a result set. An array of unsigned long integers representing the size of each column (not including any terminating null bytes). If ...
https://dev.mysql.com/mysql-num-fields.html
unsigned int mysql_num_fields(MYSQL_RES *result) To pass a MYSQL* argument instead, use unsigned int mysql_field_count(MYSQL *mysql). An unsigned integer representing the number of columns in a result set. You can get the number of columns either ...
https://dev.mysql.com/innodb-fulltext-index.html
If you want to create your own FTS_DOC_ID column, the column must be defined as BIGINT UNSIGNED NOT NULL and named FTS_DOC_ID (all upper case), as in the following example: Note The FTS_DOC_ID column does not need to be defined as an AUTO_INCREMENT ... FULLTEXT indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to help speed up queries and DML operations on data contained within those columns, omitting any words that are defined as ...
