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/set-statement.html
Descriptions for those forms that are not associated with a specific server capability appear in subsections of this section: SET var_name = value enables you to assign values to variables that affect the operation of the server or clients. SET ...
https://dev.mysql.com/doc/refman/5.7/en/views.html
Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them. Additional Resources You may find the MySQL User Forums ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-connection-strings.html
(See the documentation for the respective executable.) It is also possible to set the connection string for all nodes in the cluster at once by placing it in a [mysql_cluster] section in the management server's my.cnf file. Write the connection ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-processes.html
process_id This node's process ID angel_process_id Process ID of this node's angel process process_name Name of the executable service_URI Service URI of this node (see text) Notes node_id is the ID assigned to this node in the cluster. For an ...
https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html
Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be ...
https://dev.mysql.com/doc/refman/5.7/en/comments.html
In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or tab. If you add a version number after the ! character, the syntax within the comment is ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
Metadata lock acquisition order can make a difference in operation outcome when multiple transactions execute concurrently, as the following example illustrates. Lock acquisition order results in the RENAME TABLE executing before the INSERT. In this ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-example.html
If a statement uses subqueries, there can be mutliple preparations, optimizations, and executions, as well as subquery-specific transformations. Now we can examine the trace, whose first column (QUERY), containing the original statement to be ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The definition of an existing event can be changed by means of the ALTER EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/5.7/en/examples.html
Here are examples of how to solve some common problems with MySQL. Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Supposing that each trader has a single fixed price per ...