Search Results
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/load-data.html
The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO Statement”.) To write data from a table to a file, use SELECT ... To read the file back into a table, use LOAD DATA. The syntax of ...
https://dev.mysql.com/doc/refman/8.4/en/local-variable-scope.html
The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. Because local variables are in scope only during stored ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin directory. This program reads the files created as a result of the backup and inserts the stored ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns.html
The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session.
https://dev.mysql.com/doc/refman/8.4/en/sys-version-major.html
This function returns the major version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_major(); +-----------+---------------------+ | VERSION() | sys.version_major() | +-----------+---------------------+ | 8.4.2 | 8 | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version-minor.html
This function returns the minor version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_minor(); +-----------+---------------------+ | VERSION() | sys.version_minor() | +-----------+---------------------+ | 8.4.2 | 4 | ...
https://dev.mysql.com/doc/refman/8.4/en/sys-version-patch.html
This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +-----------+---------------------+ | VERSION() | sys.version_patch() | +-----------+---------------------+ | 8.4.2 | 2 | ...