PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-index.html
mysql-py> db.countryinfo.create_index("name", {"fields": [{"field": "$.Name", "type": "TEXT(40)", "required": True}], "unique": True}) Drop an Index To drop an index, pass the name of the index to drop to the drop_index() method. For example, you ...
https://dev.mysql.com/doc/refman/8.0/en/sys-list-drop.html
Removes a value from a comma-separated list of values and returns the result. For more information, see the description of list_add() Parameters in_list TEXT: The list to be modified.
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
Important For statement-based logging, an exception is made in the rules just given for the CREATE DATABASE, ALTER DATABASE, and DROP DATABASE statements. In those cases, the database being created, altered, or dropped replaces the default database ...The database that is checked for a match depends on the binary log format of the statement that is being ... When evaluating replication options, the replica ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
The CREATE FUNCTION and DROP FUNCTION statements require the INSERT and DROP privilege, respectively, for the mysql database. When you are upgrading, before installing the component, you must unload the legacy functions using the DROP FUNCTION ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-installation.html
The available scripts differ in the file name used to refer to the script: win_install_firewall.sql linux_install_firewall.sql The installation script creates stored procedures in the default database, mysql. Statements use IF EXISTS because, ...
https://dev.mysql.com/doc/refman/8.0/en/windows-symbolic-links.html
On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. Use of database symlinks on Windows is ...
https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html
A DROP DATABASE operation can drop tables that belong to a general tablespace but it cannot drop the tablespace, even if the DROP DATABASE operation drops all tables that belong to the tablespace. Dropping a General Tablespace The DROP TABLESPACE ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. Dropping a partition from a table that is partitioned by either RANGE or by LIST can be ...For information about working with tables that are partitioned by hash or key, see Section 26.3.2, “Management of HASH and KEY ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo.html
ndbinfo is a database containing information specific to NDB Cluster. This database contains a number of tables, each providing a different sort of data about NDB Cluster node status, resource usage, and operations. This is true even when using the ...You can find more detailed information about each of these tables in the next several ...
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...