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/mysql-shell-tutorial-javascript-table-update.html
To replace a city name in the city table, pass to the set() method the new city name. Then, pass to the where() method the city name to locate and replace. You can use the update() method to modify one or more records in a table. The update() ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-table-update.html
To replace a city name in the city table, pass to the set() method the new city name. Then, pass to the where() method the city name to locate and replace. You can use the update() method to modify one or more records in a table. The update() ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-digests.html
Consider these statements: SELECT * FROM orders WHERE customer_id=10 AND quantity>20 SELECT * FROM orders WHERE customer_id = 20 AND quantity > 100 To normalize these statements, the parser replaces data values by ? and adjusts whitespace. The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-assign-anon.html
Important A replica set up with ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS on any channel cannot be promoted to replace the replication source server in the event that a failover is required, and a backup taken from the replica cannot be used to restore ... From MySQL 8.0.23, you can set up replication channels to assign a GTID to replicated transactions that do not already have ...
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
Replace the password with the password that you want to use. Replace the password with the password that you want to use. Replace the password with the password that you want to use. If you have never assigned a root password for MySQL, the server ...
https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html
If you replace the system's /etc/localtime time zone file with a version that uses rules differing from those in effect at mysqld startup, restart mysqld so that it uses the updated rules. When a new update is available, download it and use it to ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
Additional Resources Example showing how to add a collation for full-text searches: Section 14.9.7, “Adding a User-Defined Collation for Full-Text Indexing” The Unicode Collation Algorithm (UCA) specification: ... Warning User-defined collations ...
https://dev.mysql.com/doc/refman/8.0/en/alter-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
In the name caching_sha2_password, “sha2” refers more generally to the SHA-2 class of encryption algorithms, of which 256-bit encryption is one instance. MySQL provides two authentication plugins that implement SHA-256 hashing for user account ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html
Collations for Unicode multibyte character sets Some of these collations are based on the Unicode Collation Algorithm (UCA), others are not. MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of ...