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/database-use.html
Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp | +----------+ The mysql database describes user access privileges. If the test ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
This section describes the functions that can be used to manipulate temporal values. See Section 11.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
The query-cache-hit query is triggered when a query exists in the query cache and can be used to return the query cache information. Probes exist to monitor when data is read into the keycache, cached key data is written from the cache into a cached ... MySQL supports the following static probes, organized into groups of ...
https://dev.mysql.com/doc/refman/5.7/en/explain-output.html
Not exists (JSON property: message) MySQL was able to do a LEFT JOIN optimization on the query and does not examine more rows in this table for the previous row combination after it finds one row that matches the LEFT JOIN criteria. That is, for ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
MySQL Server supports some extensions that are likely not to be found in other SQL DBMSs. Be warned that if you use them, your code is not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
When you select literal (or _introducer hexadecimal-value), do you obtain literal as a result? For example, the Japanese Katakana character Pe (ペ') exists in all CJK character sets, and has the code point value (hexadecimal coding) 0x30da. This is ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
InnoDB data-at-rest encryption is designed to transparently apply encryption within the database without impacting existing applications. Is data decrypted for users who are authorized to see it? A.17.2. What are the encryption algorithms used with ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create.html
Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. You can either create the local table and specify the connection string (containing the server name, login, password) to be used ... To create a FEDERATED table you should follow these steps: Create the table on the remote ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-usage.html
Initially, no profiles exist, so by default, the firewall accepts all statements and has no effect on which statements MySQL accounts can execute. When registering accounts in profiles, do not use wildcard characters or netmasks: Suppose that an ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ... (You can also use SHOW WARNINGS or SHOW ERRORS to see conditions or errors.) No special privileges are required to execute GET DIAGNOSTICS. The ...