Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/8.4/en/drop-tablespace.html
mysql> DROP UNDO TABLESPACE undo_003; NDB Example This example shows how to drop an NDB tablespace myts having a data file named mydata-1.dat after first creating the tablespace, and assumes the existence of a log file group named mylg (see Section ... DROP [UNDO] TABLESPACE tablespace_name This statement drops a tablespace that was previously created using CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/error-creating-innodb.html
Runtime Problems If InnoDB prints an operating system error during a file operation, usually the problem has one of the following solutions: Make sure the InnoDB data file directory and the InnoDB log directory exist. The troubleshooting steps for ...
https://dev.mysql.com/doc/refman/8.4/en/error-interfaces.html
$> ndb_perror 323 NDB error code 323: Invalid nodegroup id, nodegroup already existing: Permanent error: Application error . Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-event-fields.html
A user-defined field does not exist until created by a log filter. Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An event field may be classified as core, optional, or user-defined: A ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. The MySQL server writes some error messages to its error log. These indicate issues of interest to database administrators or that require DBA action.
https://dev.mysql.com/doc/refman/8.4/en/events-syntax.html
The definition of an existing event can be changed by means of the ALTER EVENT statement. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
row *************************** EXPLAIN: -> Filter: (t.c2 > 50) (cost=0.35 rows=1) -> Covering index scan on t using i1 (cost=0.35 rows=1) 1 row in set (0.00 sec) If the database does not exist, the statement is rejected with ER_BAD_DB_ERROR. In ...