PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
This is unsafe because the order in which the rows are updated may differ on the source and the replica. When executed against a table that contains more than one primary or unique key, this statement is considered unsafe, being sensitive to the ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Note With TRADITIONAL mode enabled, an INSERT or UPDATE aborts as soon as an error occurs. For data-change operations (INSERT, UPDATE), its effect also depends on whether strict SQL mode is enabled. Strict SQL Mode Strict mode controls how MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
sql_safe_updates System Variable sql_safe_updates Scope Global, Session Dynamic Yes SET_VAR Hint Applies Yes Type Boolean Default Value OFF If this variable is enabled, UPDATE and DELETE statements that do not use a key in the WHERE clause or a ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
UPDATE IGNORE statements, including those having an ORDER BY clause, are flagged as unsafe for statement-based replication. (This is because the order in which the rows are updated determines which rows are ignored.) Such statements produce a ...The ...
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...For dependent subqueries in the select list, no data change statements are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql ...With --safe-updates, you can modify rows only by specifying the key values that identify them, or a LIMIT clause, or ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
FOR UPDATE, and LOCK IN SHARE MODE operations without making other transactions wait. FOR UPDATE, and LOCK IN SHARE MODE operations, other transactions might have to wait. It is safe to use for all settings of the innodb_autoinc_lock_mode option. If ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
For more information about this option, see Using Safe-Updates Mode (--safe-updates). --max-join-size=value Command-Line Format --max-join-size=value Type Numeric Default Value 1000000 The automatic limit for rows in a join when using --safe-updates. --safe-updates, --i-am-a-dummy, -U Command-Line Format --safe-updates--i-am-a-dummy Type Boolean Default Value FALSE If this option is enabled, UPDATE and DELETE statements that do not use a key in the WHERE clause or a LIMIT clause produce an ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-replica.html
For storage engines other than NDB, IDEMPOTENT mode should be used only when you are absolutely sure that duplicate-key errors and key-not-found errors can safely be ignored. For storage engines other than NDB, IDEMPOTENT mode should be used only ...
https://dev.mysql.com/doc/refman/8.0/en/mysqld-safe.html
mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. On these platforms, mysqld_safe is not ...