Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-table-delete.html
Drop a Table The drop_collection() method is also used in MySQL Shell to drop a relational table from a database. For example, to drop the citytest table from the world_x database, issue: mysql-py> db.drop_collection("citytest") Related Information ... You can use the delete() method to remove some or all records from a table in a ...The X DevAPI provides additional ...
https://dev.mysql.com/doc/refman/8.4/en/stored-program-restrictions.html
For example, you cannot have two events in the same database with the names anEvent and AnEvent. An event may not be altered, or dropped from within a stored program, if the event name is specified by means of a variable. An event also may not ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-sharing.html
JSON_OBJECT sets key-value pairs for the database and table of the exported table to import. Optionally, use the database with the output table and query a sample. This topic describes how to grant other users access to a model you create. Before ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
This is useful, for example, for a database administrator who configures the firewall, to avoid the possibility of a misconfiguration causing even the administrator to be locked out and unable to execute statements. Grant the EXECUTE privilege for ... Before using MySQL Enterprise Firewall, install it according to the instructions provided in Section 8.4.7.2, “Installing or Uninstalling MySQL Enterprise ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbdictionary.html
This section provides information about the NdbDictionary class, which stores meta-information about NDB database objects, such as tables, columns, and indexes. While the preferred method of database object creation and deletion is through the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. --database=dbname, -d Command-Line Format --database=name Type String Default Value TEST_DB Name ...ndb_move_data options source target Options that can be used with ndb_move_data are shown in the following ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-config-ui.html
Database: limits the queries to those executed within a specific database. The database match is performed using the LIKE match from the MySQL database, hence you can use the % and _ characters to multiple and single character matches. Figure 32.10 ... The Configuration View enables you to customize the data displayed on the Query Analyzer ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...This is true regardless of whether the replica is a single server or a ...
https://dev.mysql.com/doc/workbench/en/wb-creating-eer-diagram.html
To create an EER diagram for the sakila database, first add an EER diagram by double-clicking the Add Diagram icon in the EER Diagrams panel to create and open a new EER Diagram editor. You can add tables to the EER canvas by dragging them from the ...To add a table to the canvas, select the Catalog tab in the middle panel on the right side of the application to display any schemas that appear in the MySQL Model ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-error.html
This exception is the base class for all other exceptions in the errors module. It can be used to catch all errors in a single except statement. errors.Error is internally used by Connector/Python to raise MySQL client and server errors and should ...