https://dev.mysql.com/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals The following grammar ...
https://dev.mysql.com/extensions-to-ansi.html
Data types The MEDIUMINT, SET, and ENUM data types, and the various BLOB and TEXT data types. MySQL Server supports some extensions that you probably will not find in other SQL DBMSs. Be warned that if you use them, your code will not be portable ...
https://dev.mysql.com/federated-usagenotes.html
For example, creating a FEDERATED table with an index prefix on VARCHAR, TEXT or BLOB columns will fail. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The ...
https://dev.mysql.com/func-op-summary-ref.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). GTID_SUBTRACT() Return all GTIDs in set that are not in subset. WEEK() Return the week number WEEKDAY() Return the weekday ...
https://dev.mysql.com/general-thread-states.html
FULLTEXT initialization The server is preparing to perform a natural-language full-text search. The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/group-by-functions.html
The result type is TEXT or BLOB unless group_concat_max_len is less than or equal to 512, in which case the result type is VARCHAR or VARBINARY. This section describes group (aggregate) functions that operate on sets of values. If you use a group ...
https://dev.mysql.com/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 5.1.14, ...
https://dev.mysql.com/index-merge-optimization.html
The Index Merge access method retrieves rows with multiple range scans and merges their results into one. This access method merges index scans from a single table only, not scans across multiple tables. The merge can produce unions, intersections, ...
https://dev.mysql.com/information-schema-introduction.html
You can filter, sort, concatenate, and transform the results from INFORMATION_SCHEMA queries into whatever format your application needs, such as a data structure or a text representation to parse. INFORMATION_SCHEMA provides access to database ...
https://dev.mysql.com/innodb-backup.html
Dumped tables are stored into text files that are human-readable, so spotting table corruption becomes easier. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, ...
