https://dev.mysql.com/scalar-subqueries.html
For example, LIMIT requires literal integer arguments, and LOAD DATA requires a literal string file name. In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it ...
https://dev.mysql.com/show-index.html
Cardinality is counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table ...
https://dev.mysql.com/spatial-function-argument-handling.html
In MySQL, the SRID value is an integer associated with the geometry value. Spatial values, or geometries, have the properties described at Section 11.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional ...
https://dev.mysql.com/spatial-geojson-functions.html
The srid argument, if given, must be a 32-bit unsigned integer. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are ...
https://dev.mysql.com/statistics-table.html
CARDINALITY is counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If ...
https://dev.mysql.com/udf-features.html
The MySQL interface for user-defined functions provides the following features and capabilities: Functions can return string, integer, or real values and can accept arguments of those same types. You can define simple functions that operate on a ...
https://dev.mysql.com/user-variables.html
User variables can be assigned a value from a limited set of data types: integer, decimal, floating-point, binary or nonbinary string, or NULL value. You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/using-date.html
When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, or BETWEEN operators, MySQL normally converts the string to an internal long integer for faster comparison (and also for a bit more “relaxed” ...
https://dev.mysql.com/validate-password.html
This function takes a password argument and returns an integer from 0 (weak) to 100 (strong). The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This ...
https://dev.mysql.com/writing-full-text-plugins.html
MySQL supports server-side full-text parser plugins with MyISAM and InnoDB. For introductory information about full-text parser plugins, see Full-Text Parser Plugins. A full-text parser plugin can be used to replace or modify the built-in full-text ...
