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/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.
https://dev.mysql.com/doc/refman/5.7/en/xa-states.html
An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
mysqld_safe reads options from the [mysqld], [server], [mysqld_safe], and [safe_mysqld] groups. An embedded MySQL server usually reads options from the [server], [embedded], and [xxxxx_SERVER] groups, where xxxxx is the name of the application into ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...