PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); ...
https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html
MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are enabled. Possible destinations for log entries are log files or the general_log and slow_log tables in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-retries Command-Line ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-count.html
ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the result is equivalent to that obtained by using the MySQL statement SELECT COUNT(*) FROM tbl_name. Usage ndb_select_count [-c connection_string] -ddb_name ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/refman/8.0/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...
https://dev.mysql.com/doc/refman/8.0/en/select-benchmarking.html
To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The return value is always zero, but mysql prints a line displaying approximately how long the statement took to ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-features-to-trace.html
Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason. They are: Greedy search: With an N-table join, this could explore factorial(N) plans. Range ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression operations. MySQL implements regular ...
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html
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 mode. As a result, the address value for rows within each name group is ...