PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
--useHexFormat -x Causes all numeric values to be displayed in hexadecimal format. This does not affect the output of numerals contained in strings or datetime values. ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndbinfo-select-all.html
--delay=seconds Command-Line Format --delay=# Type Numeric Default Value 5 Minimum Value 0 Maximum Value MAX_INT This option sets the number of seconds to wait between executing loops. --loops=number, -l number Command-Line Format --loops=# Type ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
Comparison of dissimilar columns (comparing a string column to a temporal or numeric column, for example) may prevent use of indexes if values cannot be compared directly without conversion. For a given value such as 1 in the numeric column, it ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-indexes-create.html
The following example specifies an index named popul, defined against the Population field from the demographics object, indexed as an Integer numeric value. mysql-js> db.countryinfo.createIndex("popul", {fields: [{field: ... Indexes are used to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-index.html
The following example specifies an index named popul, defined against the Population field from the demographics object, indexed as an Integer numeric value. mysql-py> db.countryinfo.createIndex("popul", {fields: [{field: ... Indexes are used to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
Suppose that an indexed string column c1 is compared to a numeric value using WHERE c1 = 2222. For such comparisons, the string value is converted to a number and the operands are compared numerically (see Section 14.3, “Type Conversion in ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldumpslow.html
-n N Type Numeric Abstract numbers with at least N digits within names. -t N Type Numeric Display only the first N queries in the output. The MySQL slow query log contains information about queries that take a long time to execute (see Section ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-character.html
See Section 10.4.2.1, “Optimizing for Numeric Data” for reasons why a numeric column is usually preferable to an equivalent string column. For character and string columns, follow these guidelines: Use binary collation order for fast comparison ...
https://dev.mysql.com/doc/refman/8.0/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...