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/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-unused-indexes.html
These views display indexes for which there are no events, which indicates that they are not being used. This view is most useful when the server has been up and processing long enough that its workload is representative. Otherwise, presence of an ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version.html
This view provides the current sys schema and MySQL server versions. Note As of MySQL 5.7.28, this view is deprecated and subject to removal in a future MySQL version. Applications that use it should be migrated to use an alternative instead. For ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
However, this is not the case: The second query returns 0. mysql> SELECT STRCMP(@s1, @s3); ERROR 1267 (HY000): Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_general_cs,IMPLICIT) for operation 'strcmp' mysql> SELECT STRCMP(@s1, ... Table 12.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the resulting string is also a binary ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-reload-saved.html
This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. Reloads a Performance Schema configuration saved earlier within the same session using ps_setup_save(). That is a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-thread_concurrency.html
In situations where it is helpful to minimize context switching between threads, InnoDB can use a number of techniques to limit the number of concurrently executing operating system threads (and thus the number of requests that are processed at any ...Scalability improvements in MySQL 5.5 and up reduce the need to limit the number of concurrently executing threads inside ...
https://dev.mysql.com/doc/refman/5.7/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
If there is an error in evaluation on the replica, particularly when executing complex statements, statement-based replication may slowly increase the margin of error across the affected rows over time. For complex statements, the statement must be ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/5.7/en/connection-management.html
This includes a description of the available connection interfaces, how the server uses connection handler threads, details about the administrative connection interface, and management of DNS lookups.