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/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 ...
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/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/update-optimization.html
An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data being updated and the number of indexes that are updated. Another way to get fast updates is to delay ...If you do this often, it is very important to use OPTIMIZE TABLE ...
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/ansi-diff-update.html
If you access a column from the table to be updated in an expression, UPDATE uses the current value of the column. The second assignment in the following statement sets col2 to the current (updated) col1 value, not the original col1 value. UPDATE ...The result is that col1 and col2 have the same ...