PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset.html
MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of collations. The default MySQL server character set and collation are latin1 and ...
https://dev.mysql.com/doc/refman/5.7/en/compatibility.html
Selecting SQL Modes The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. This section describes how MySQL relates to the ANSI/ISO ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
SELECT statements, MySQL Server stores the implicit default value for the column data type. You can select stricter treatment of input values by using the STRICT_TRANS_TABLES or STRICT_ALL_TABLES SQL modes: SET sql_mode = 'STRICT_TRANS_TABLES'; SET ... MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts the statement in which they occur (see Section 5.1.10, “Server SQL ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. GRANT and REVOKE assign privileges to and revoke privileges from accounts. Account-management statements cause the ...
https://dev.mysql.com/doc/refman/5.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-conversion.html
To some extent, you can convert a value from one temporal type to another. However, there may be some alteration of the value or loss of information. In all cases, conversion between temporal types is subject to the range of valid values for the ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
Examples: SELECT SEC_TO_TIME(SUM(TIME_TO_SEC(time_col))) FROM tbl_name; SELECT FROM_DAYS(SUM(TO_DAYS(date_col))) FROM tbl_name; Note The MySQL server can be run with the MAXDB SQL mode enabled. The date and time data types for representing temporal ...
https://dev.mysql.com/doc/refman/5.7/en/displaying-traces.html
As noted previously, you should ensure that end_markers_in_json is OFFwhen executing the SELECT INTO statement, so that the output is valid JSON. Examining a trace in the mysql command-line client can be made less difficult using the pager less ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
Do not select ECDSA ciphers unless you have an ECDSA certificate available to you. MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted connections. It is also possible to ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. Use the private key to encrypt data and the public key to decrypt it This requires that the members of the key ...