MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 581 to 590 of 593 total results

https://dev.mysql.com/doc/refman/8.0/en/traceable-statements.html

Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...

10.15.12 Example

https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html

Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...

6.2.7 Connection Transport Protocols

https://dev.mysql.com/doc/refman/8.0/en/transport-protocols.html

For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. This section describes how to ...

Chapter 5 Tutorial

https://dev.mysql.com/doc/refman/8.0/en/tutorial.html

This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program ...

2.6 Installing MySQL Using Unbreakable Linux Network (ULN)

https://dev.mysql.com/doc/refman/8.0/en/uln-installation.html

Linux supports a number of different solutions for installing MySQL, covered in Section 2.5, “Installing MySQL on Linux”. One of the methods, covered in this section, is installing from Oracle's Unbreakable Linux Network (ULN). You can find ...

3.7 Upgrading MySQL Binary or Package-based Installations on Unix/Linux

https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html

This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place Upgrade Logical Upgrade MySQL Cluster Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the ...

8.3.1 Configuring MySQL to Use Encrypted Connections

https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html

Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key files. See Section 20.6.2, “Securing Group Communication Connections with Secure Socket Layer ...

7.1.9 Using System Variables

https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html

The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...

15.2.19 VALUES Statement

https://dev.mysql.com/doc/refman/8.0/en/values.html

VALUES is a DML statement introduced in MySQL 8.0.19 which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as a standalone SQL statement. VALUES row_constructor_list [ORDER BY ...

7.6.6.3 Using Version Tokens

https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html

Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version Tokens”. A scenario in which Version Tokens can be useful is a system that accesses a collection of MySQL ...

Displaying 581 to 590 of 593 total results