PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html
For example: mysql> SELECT * FROM employees.employees WHERE emp_no = 10001; +--------+------------+------------+-----------+--------+------------+ | emp_no | birth_date | first_name | last_name | gender | hire_date | ... The following example ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
Warnings occur under these circumstances: A deprecation warning is raised when selecting from the INFORMATION_SCHEMA tables. Applications must be revised as follows to run properly: Selecting from the INFORMATION_SCHEMA tables produces an error.
https://dev.mysql.com/doc/refman/5.7/en/problems-with-float.html
If columns d1 and d2 had been defined as DECIMAL rather than DOUBLE, the result of the SELECT query would have contained only one row—the last one shown above. Suppose that you execute the following statements: CREATE TABLE t1(c1 FLOAT(53,0), c2 ... Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
Only those statements are written to the binary log where the default database (that is, the one selected by USE) is db_name. To specify more than one database, use this option multiple times, once for each database; however, doing so does not cause ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/show-warnings.html
The LIMIT clause has the same syntax as for the SELECT statement. You can also retrieve this number from the warning_count system variable: SHOW COUNT(*) WARNINGS; SELECT @@warning_count; A difference in these statements is that the first is a ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
This includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE. A function can process a result set either with SELECT ... (See also Bug #16522.) Each execution of the statements ...Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/view-syntax.html
A view can be created from many kinds of SELECT statements. The CREATE VIEW statement creates a new view (see Section 13.1.21, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 13.1.10, ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-foreign-keys.html
For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent rows. If ON UPDATE CASCADE or ON UPDATE SET NULL recurses to update the same table it ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
If you do not say SET NAMES or SET CHARACTER SET, then for SELECT column1 FROM t, the server sends back all the values for column1 using the character set that the client specified when it connected. On the other hand, if you say SET NAMES 'latin1' ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
Consider these statements: SET NAMES utf8; SELECT 'abc'; SELECT _utf8'def'; SELECT N'MySQL'; Although the character set is utf8 in each of the preceding cases, the strings do not actually contain any characters outside the ASCII range, so their ...