Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
This is an example of a minimal CREATE EVENT statement: CREATE EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE myschema.mytable SET mycol = mycol + 1; The previous statement creates an event named myevent. This event ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-data-types.html
These and later versions of the MySQL Server and NDB Cluster use the new temporal types by default, can read and write data using the old temporal types, but cannot create tables that use the old types. This section provides information about the ...The MySQL TINYINT, SMALLINT, INT, and BIGINT data types map to NDB types having the same names and storage requirements as their MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
The following example demonstrates creating and configuring a new global stopword table for InnoDB. To see the default InnoDB stopword list, query the Information Schema INNODB_FT_DEFAULT_STOPWORD table. The stopword table must have a single VARCHAR ... The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-adapter.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using array adapters of the type defined in common/array_adapter.hpp (see Section 2.5.15, “Common Files for NDB API Array Examples”). static ...
https://dev.mysql.com/doc/refman/8.4/en/bug-reports.html
If a database table is related to the problem, include the output from the SHOW CREATE TABLE db_name.tbl_name statement in the bug report. You should also include the output from SHOW CREATE TABLE tbl_name for each table that is involved. If you ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-indexes.html
ALTER INDEX operation: ALTER TABLE t1 ALTER INDEX i_idx INVISIBLE; ALTER TABLE t1 ALTER INDEX i_idx VISIBLE; Information about whether an index is visible or invisible is available from the Information Schema STATISTICS table or SHOW INDEX output.
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-operations-per-fragment.html
This currently has the following formats: Base table: DbName/def/TblName BLOB table: DbName/def/NDB$BLOB_BaseTblId_ColNo Ordered index: sys/def/BaseTblId/IndexName Unique index: sys/def/BaseTblId/IndexName$unique The $unique suffix shown for unique ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbdictionary.html
These include the following inner classes: Table for working with tables Column for creating table columns Index for working with secondary indexes Dictionary for creating database objects and making schema enquiries Event for working with events in ... This section provides information about the NdbDictionary class, which stores meta-information about NDB database objects, such as tables, columns, and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
The DROP TABLE and CREATE TABLE statements are not executed because the default database is not db1, even though the statements name a table in db1. The INSERT and CREATE TABLE statements are executed because the default database is db1, even though ...This option is on by default, which enables database, table, and column name ... mysql supports the following options, which can be ...