Search Results
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
You should not use ANALYZE TABLE, REPAIR TABLE, OPTIMIZE TABLE, ALTER TABLE, DROP TABLE, DELETE without a WHERE clause, or TRUNCATE TABLE on any of the tables that are mapped into an open MERGE table. DROP TABLE on a table that is in use by a MERGE ... The following are known problems with MERGE tables: MERGE child tables are locked through the parent ...
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
By default, tables are created in the default database, using the InnoDB storage engine. An error occurs if the table exists, if there is no default database, or if the database does not exist. This works regardless of whether there is a default ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
This function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement: CREATE TABLE t (c VARCHAR(288) DEFAULT (CURRENT_USER())); DATABASE() Returns the default (current) database name as a ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
If you alter the database default character set or collation, stored routines that are to use the new database defaults must be dropped and recreated. By default, a stored routine is associated with the default database. To associate the routine ...
https://dev.mysql.com/doc/workbench/en/wb-data-modeling-menus.html
Include Model: Adds the database objects defined within an existing model file to the active MySQL model and to its diagram, if applicable. MySQL Workbench handles the script as follows: If the script does not contain a CREATE DATABASE db_name; ...
https://dev.mysql.com/doc/refman/8.4/en/symbolic-links-to-tables.html
Note When you drop a table that is using symlinks, both the symlink and the file to which the symlink points are dropped. This is an extremely good reason not to run mysqld as the root operating system user or permit operating system users to have ... Note Symbolic link support as described here, along with the --symbolic-links option that controls it, and is deprecated; expect these to be removed in a future version of ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
How do I import an existing MySQL database into an NDB Cluster? A.10.28. What do “NDB” and “NDBCLUSTER” mean? “NDB” stands for “Network Database”. There must be sufficient memory on machines used for data nodes to hold each node's ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-simple-dual.html
This example demonstrates synchronous transactions and connecting to multiple clusters in a single NDB API application. The source code for this program may be found in the NDB Cluster source tree, in the file ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-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/mysql-shell-tutorial-javascript-table-delete.html
Drop a Table The dropCollection() 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-js> session.dropCollection("world_x", "citytest") ...The ...