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/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 25.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
The optional FULL modifier causes SHOW TABLES to display a second output column with values of BASE TABLE for a table, VIEW for a view, or SYSTEM VIEW for an INFORMATION_SCHEMA table. SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
Item Name Definition --------- ---------- CLASS_ORIGIN VARCHAR(64) SUBCLASS_ORIGIN VARCHAR(64) CONSTRAINT_CATALOG VARCHAR(64) CONSTRAINT_SCHEMA VARCHAR(64) CONSTRAINT_NAME VARCHAR(64) CATALOG_NAME VARCHAR(64) SCHEMA_NAME VARCHAR(64) TABLE_NAME ...
https://dev.mysql.com/doc/refman/5.7/en/socket-pluggable-authentication.html
If the names do not match, the plugin checks whether the socket user name matches the name specified in the authentication_string column of the mysql.user system table row. The server-side auth_socket authentication plugin authenticates clients ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
In the Default column, PREFIX stands for the value of the CMAKE_INSTALL_PREFIX option, which specifies the installation base directory. The CMake program provides a great deal of control over how you configure a MySQL source distribution.
https://dev.mysql.com/doc/refman/5.7/en/source-thread-states.html
The following list shows the most common states you may see in the State column for the Binlog Dump thread of the replication source. If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engine-setting.html
For new tables, MySQL always creates an .frm file to hold the table and column definitions. When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
The value in the Support column indicates whether an engine can be used. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage engine, and Oracle ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
As of MySQL 5.7.19, an exception to the preceding principle occurs for expressions for virtual generated columns. MySQL has many operators and functions that return a string. This section answers the question: What is the character set and ...