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/replication-features-create-select.html
SELECT statement to make any changes in tables other than the table that is created by the statement. SELECT statement causing changes in other tables on the source fails on the replica, causing replication to stop. SELECT statement fails following ...Some older versions of MySQL permitted these statements to do so; this means that, when using replication between a MySQL 5.6 or later replica and a source running a previous version of MySQL, a CREATE TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser does not seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-in-select.html
Two query cache-related options may be specified in SELECT statements: SQL_CACHE The query result is cached if it is cacheable and the value of the query_cache_type system variable is ON or DEMAND. Examples: SELECT SQL_CACHE id, name FROM customer; ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/windows-select-server.html
The following table shows the available servers for Windows in MySQL 5.7. Binary Description mysqld Optimized binary with named-pipe support mysqld-debug Like mysqld, but compiled with full debugging and automatic memory allocation checking All of ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
The following query selects all rows with a date_col value from within the last 30 days: mysql> SELECT something FROM tbl_name -> WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col; The query also selects rows with dates that lie in the future.
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
mysql> SELECT ASCII('2'); -> 50 mysql> SELECT ASCII(2); -> 50 mysql> SELECT ASCII('dx'); -> 100 See also the ORD() function. mysql> SELECT BIN(12); -> '1100' BIT_LENGTH(str) Returns the length of the string str in bits. mysql> SELECT ...For ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); -> 32 This function is safe to use with BIGINT values. mysql> SELECT ACOS(1); -> 0 mysql> SELECT ACOS(1.0001); -> NULL mysql> SELECT ACOS(0); -> 1.5707963267949 ASIN(X) Returns the arc sine of X, ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
The general_log system variable controls logging to the general query log for the selected log destinations. Similarly, the slow_query_log variable controls logging to the slow query log for the selected destinations and setting slow_query_log_file ... MySQL Server provides flexible control over the destination of output written to the general query log and the slow query log, if those logs are ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --ndb-optimized-node-selection ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-count.html
ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the result is equivalent to that obtained by using the MySQL statement SELECT COUNT(*) FROM tbl_name. Usage ndb_select_count [-c connection_string] -ddb_name ...--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving ...