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-python-table-insert.html
Each value must match the data type of the column it represents. For example, to add a new record to the city table in the world_x database, insert the following record and press Enter twice. mysql-py> db.city.insert("ID", "Name", ... You can use ...
https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source.html
This is because the server IDs of replicas must be unique in a replication topology. Channel specific replication filters can be used when the same database or table is present on multiple sources, and you only need the replica to replicate it from ...You might choose to implement multi-source replication to achieve goals like these: Backing up multiple servers to a single ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
This file is located in the directory named by the character_sets_dir system variable. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; ... To add ...Choose a collation ID, as shown in Section 12.14.2, “Choosing a Collation ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
(That is, the statement fails if dropping an account would cause a stored object to become orphaned.) To perform the operation anyway, you must have the SET_USER_ID privilege; in this case, the statement succeeds with a warning rather than failing ...To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
(A warning occurs for statements that otherwise would not be permitted.) authentication_policy values can be defined in an option file or specified using a SET GLOBAL statement: SET GLOBAL authentication_policy='*,*,'; There are several rules that ... Authentication involves one party establishing its identity to the satisfaction of a second ...
https://dev.mysql.com/doc/refman/8.0/en/table-locking.html
InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. The automatic row-level locking makes these ...For this storage engine, avoid using the LOCK TABLES statement, because it does not offer any extra protection, but instead reduces ...
https://dev.mysql.com/doc/refman/8.0/en/creating-database.html
Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL keywords), so you must always refer to your database as menagerie, not as Menagerie, MENAGERIE, or some other ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-function-argument-handling.html
For computations on multiple geometry values, all values must be in the same SRS or an error occurs. This provides additional flexibility to users because it is unnecessary to be concerned about the uniqueness of geometry data. Spatial values, or ...Each geometry value is associated with a spatial reference system (SRS), which is a coordinate-based system for geographic ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
If an index made invisible actually is needed or used by the optimizer, there are several ways to notice the effect of its absence on queries for the table: Errors occur for queries that include index hints that refer to the invisible index. MySQL ...Dropping and re-adding an index can be expensive for a large table, whereas making it invisible and visible are fast, in-place ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
If a filesort must be done, all rows that match the query without the LIMIT clause are selected, and most or all of them are sorted, before the first row_count are found. If you need only a specified number of rows from a result set, use a LIMIT ...