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/replication-options-reference.html
Slave_rows_last_search_algorithm_used: Search algorithm most recently used by this replica to locate rows for row-based replication (index, table, or hash scan). gtid_executed_compression_period: Compress gtid_executed table each time this many ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
To search for \, specify it as \\\\; this is because the backslashes are stripped once by the parser and again when the pattern match is made, leaving a single backslash to be matched against. (Unless the NO_BACKSLASH_ESCAPES SQL mode is enabled, in ... 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/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. This includes any ...
https://dev.mysql.com/doc/refman/5.7/en/backup-policy.html
This backup operation acquires a global read lock on all tables at the beginning of the dump (using FLUSH TABLES WITH READ LOCK). As soon as this lock has been acquired, the binary log coordinates are read and the lock is released. While the server ...A full backup (a snapshot of the data at a point in time) can be done in MySQL with several ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
In this Manual, we use dashes in option names, except where underscores are significant. An exception to this rule is the option for specifying your MySQL password. This option can be given in long form as --password=pass_val or as --password. This ... Program options specified on the command line follow these rules: Options are given after the command ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-linux-quick.html
This is an example of the subrepository's default entry in the file (the baseurl entry in your file might look different, depending on your Linux distribution): [mysql-tools-preview] name=MySQL Tools Preview ...To do so, you need to remove your old ... Note Installation packages for MySQL Shell are available only for a limited number of Linux distributions, and only for 64-bit ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command Line”. To start multiple servers this way, you can specify the appropriate options on the ...It is more convenient to place the options in an option file, but it is necessary to make sure that each server gets its own set of ...
https://dev.mysql.com/doc/refman/5.7/en/assignment-operators.html
The value on the right hand side may be a literal value, another variable storing a value, or any legal expression that yields a scalar value, including the result of a query (provided that this value is a scalar value). This means you can use := in ... Table 12.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment ...
https://dev.mysql.com/doc/refman/5.7/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
In this case, the optimizer uses heuristics to estimate a filtering effect of 16.31% for the BETWEEN condition on employee.hire_date. This flag is enabled by default but can be disabled to suppress condition filtering (for example, if a particular ... In join processing, prefix rows are those rows passed from one table in a join to the ...