PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/precision-math-expressions.html
With precision math, exact-value numbers are used as given whenever possible. For example, numbers in comparisons are used exactly as given without a change in value. In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or ...
https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/9.7/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/9.7/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/9.7/en/locking-service.html
MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service routines. As a C language interface, callable as a plugin service from server ...
https://dev.mysql.com/doc/refman/9.7/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-index-stat.html
ndb_index_stat provides per-fragment statistical information about indexes on NDB tables. This includes cache version and age, number of index entries per partition, and memory consumption by indexes. Running ndb_index_stat with the --update option ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-print-backup-file.html
Usage ndb_print_backup_file [-P password] file_name file_name is the name of a cluster backup file. This can be any of the files (.Data, .ctl, or .log file) found in a cluster backup directory. These files are found in the data node's backup ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-waiter.html
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then exits. By default, it waits for the cluster to achieve STARTED ...