PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/precision-math-examples.html
That is, for two numbers X1 and X2 that have scale S1 and S2, the scale of the result is S1 + S2: mysql> SELECT .01 * .01; +-----------+ | .01 * .01 | +-----------+ | 0.0001 | +-----------+ Example 3. Rounding behavior for exact-value numbers is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
If cas_column and expire_time_column fields of the innodb_memcached.containers table are set to NULL, the following error is returned when attempting to load the memcached plugin: InnoDB_Memcached: column 6 in the entry for config table 'containers' ...If you encounter the following error in the MySQL error log, the server might fail to start: failed to set rlimit for open ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
See Section 9.4, “User-Defined Variables”, for more information and examples of workarounds. A user variable cannot be used directly in an SQL statement as an identifier or as part of an identifier. If you have databases or tables from an older ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
You may also find the MySQL User Forums to be helpful. Is there a discussion forum for INFORMATION_SCHEMA? See the MySQL User Forums. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Can I add to or otherwise modify ...Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA? ...
https://dev.mysql.com/doc/refman/5.7/en/thread-commands.html
Refresh The thread is flushing table, logs, or caches, or resetting status variable or replication server information. A thread can have any of the following Command values: Binlog Dump This is a thread on a replication source for sending binary ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
<in_optimizer>(query fragment) This is an internal optimizer object with no user significance. <ref_null_helper>(expr) This is an internal optimizer object with no user significance. For SELECT statements, the EXPLAIN statement produces extra ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
See X DevAPI User Guide for in-depth tutorials on using X DevAPI. Relational databases such as MySQL usually required a document schema to be defined before documents can be stored. This differs from working with a relational database and storing ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
With --all-databases or --databases, mysqldump writes CREATE DATABASE and USE statements prior to the dump output for each database. If you want to cause the dump file to force a drop of each database before recreating it, use the ... This section ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
For nonbinary strings, the unit is the character and some character sets support multibyte characters; comparisons use numeric character code values. These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; ...Every binary string has a character set and collation named ... A string is a sequence of bytes or characters, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility.html
The ib-file set includes the following files: The system tablespace (one or more ibdata files) that contain internal system information (including internal catalogs and undo information) and may include user data and indexes. To minimize the chance ... InnoDB incorporates several checks to guard against the possible crashes and data corruptions that might occur if you run an old release of the MySQL server on InnoDB data files that use a newer file ...