Search Results
https://dev.mysql.com/doc/refman/8.4/en/integer-types.html
MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. The following table shows the required storage and range for each ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-brokers.html
Create an account at Freenet6 by visiting this URL and signing up: http://gogonet.gogo6.com After creating the account, go to this URL, sign in, and create a user ID and password for the IPv6 broker: ... If you do not have a public IPv6 address that ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
Note To store values generated by INET_ATON(), use an INT UNSIGNED column rather than INT, which is signed. If you use a signed column, values corresponding to IP addresses for which the first octet is greater than 127 cannot be stored correctly. A ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-example.html
One deviation from the standard INI format is that the parameter name and value can be separated by a colon (:) as well as the equal sign (=); however, the equal sign is preferred. To support NDB Cluster, you should update my.cnf as shown in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
When --load-data-local-dir applies, the option value designates the directory in which local data files must be located. If LOCAL capability is disabled, the --load-data-local-dir option can be used to permit restricted local loading of files ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
This statement prevents new GTIDs from being generated and assigned to the transactions in the dump file as they are executed, so that the original GTIDs for the transactions are used. You can either replace the value of gtid_purged with a specified ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.4/en/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. Numbers may be preceded by - or + to indicate a negative or positive value, respectively. Numbers represented in scientific notation ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-numbers.html
The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals. Approximate-value data types and numeric literals are handled as floating-point numbers.
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
If the server has a mix of InnoDB transactions and non-InnoDB transactions, the compression controlled by this system variable interferes with the work of this process and can slow it significantly. This variable is mainly useful for testing and ...