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/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 24.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Deprecated INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
0 means no statement is executing, 1 means it is in the first 10ms, and so forth. The xxx_WAIT columns of the TP_THREAD_GROUP_STATS table accumulate counts for each wait type. The TP_THREAD_STATE table has one row per thread created by the thread ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/5.7/en/call.html
To get back a value from a procedure using an OUT or INOUT parameter, pass the parameter by means of a user variable, and then check the value of the variable after the procedure returns. When the procedure returns, a client program can also obtain ... CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/migrating-from-year2.html
This section describes problems that can occur when using the 2-digit YEAR(2) data type and provides information about converting existing YEAR(2) columns to 4-digit year-valued columns, which can be declared as YEAR with an implicit display width ...If you reload the table from the dump file, all resulting rows have internal value 2012 and display value 12, thus losing the distinctions between ...
https://dev.mysql.com/doc/refman/5.7/en/triggers.html
Additional Resources You may find the MySQL User Forums helpful when working with triggers. A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. A trigger can be set ...Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on values involved in an ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
The stopword list applies, controlled by innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for InnoDB search indexes, and ft_stopword_file for MyISAM ones. Whether a word is too short is determined from ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-consistent-read.html
A consistent read does not set any locks on the tables it accesses, and therefore other sessions are free to modify those tables at the same time a consistent read is being performed on the table. SELECT that do not specify FOR UPDATE or LOCK IN ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature.html
Setting up a web of trust is one method for trusting them. Otherwise, see http://www.gnupg.org/ for more information about GnuPG and how to obtain and install it. To verify the signature for a specific package, you first need to obtain a copy of our ... Another method of verifying the integrity and authenticity of a package is to use cryptographic ...