PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.3Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...
https://dev.mysql.com/doc/refman/5.7/en/timezone-problems.html
If you have a problem with SELECT NOW() returning values in UTC and not your local time, you have to tell the server your current time zone. This should be done for the environment in which the server runs (for example, in mysqld_safe or ...
https://dev.mysql.com/doc/refman/5.7/en/truncate-table.html
Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, it bypasses the DML method of deleting data. Thus, it cannot be rolled back, it ...
https://dev.mysql.com/doc/refman/5.7/en/use.html
USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. This statement requires some privilege for the database or some object within it. The named database remains the ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-elements.html
Version Tokens is based on a plugin library that implements these elements: A server-side plugin named version_tokens holds the list of version tokens associated with the server and subscribes to notifications for statement execution events. The ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens.html
MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. The Version Tokens interface has these characteristics: Version ...
https://dev.mysql.com/doc/refman/5.7/en/while.html
[begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the search_condition expression is true. statement_list consists of one or more SQL statements, each ...
https://dev.mysql.com/doc/refman/5.7/en/windows-and-ssh.html
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 account. Either do a remote forward (Set local_port: 3306, remote_host: ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. This section helps you diagnose and correct some of these errors. Your first resource when troubleshooting server ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-option-variable-reference.html
This table provides an overview of the command options, system variables, and status variables provided by X Plugin.