https://dev.mysql.com/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a subquery: SELECT * FROM t1 WHERE column1 = (SELECT column1 FROM t2); In this example, SELECT * ...
https://dev.mysql.com/testing-server.html
After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works satisfactorily. This section assumes that your current location is the MySQL installation directory and that it has a bin ...
https://dev.mysql.com/time.html
The only delimiter recognized between a time part and a fractional seconds part is the decimal point. By default, values that lie outside the TIME range but are otherwise valid are clipped to the closest endpoint of the range. MySQL retrieves and ...
https://dev.mysql.com/user-variables.html
User variables can be assigned a value from a limited set of data types: integer, decimal, floating-point, binary or nonbinary string, or NULL value. You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/using-encrypted-connections.html
At this point, those changes have no effect on new connections, and corresponding context-related system and status variables may have different values. Several options are available to indicate whether to use encrypted connections, and to specify ...
https://dev.mysql.com/using-systemd.html
This might be a problem if the data directory is a remote mount that has temporarily disappeared: The mount point would appear to be an empty data directory, which then would be initialized as a new data directory. If you install MySQL from a source ...
https://dev.mysql.com/version-tokens-reference.html
At this point, any statement sent by the client fails, unless the server token list changes such that it matches again. The following discussion serves as a reference to these Version Tokens components: Version Tokens Functions Version Tokens ...
https://dev.mysql.com/view-updatability.html
Earlier discussion in this section pointed out that a view is not insertable if not all columns are simple column references (for example, if it contains columns that are expressions or composite expressions). Some views are updatable and ...
https://dev.mysql.com/window-functions-frames.html
The frame_extent value indicates the start and end points of the frame. The definition of a window used with a window function can include a frame clause. A frame is a subset of the current partition and the frame clause specifies how to define the ...
https://dev.mysql.com/windows-and-ssh.html
At this point, you should have an ODBC connection to MySQL, encrypted using SSH. This section describes how to get an encrypted connection to a remote MySQL server with SSH. This userid value might not be the same as the user name of your MySQL ...
