Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
See Section 15.1.20, “CREATE TABLE Statement”, for additional information about PARTITION BY LIST COLUMNS() syntax. This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types ...
https://dev.mysql.com/doc/internals/en/transactions-notes-on-ddl-and-normal-transaction.html
DDL statements use a form of "semantic" logging to maintain atomicity: If CREATE TABLE t .. In addition, some DDL statements issue interim transaction commits: for example, ALTER TABLE issues a commit after data is copied from the original table to ... DDL statements and operations with nontransactional engines do not "register" in thd->transaction lists, and thus do not modify the transaction ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-basic-insert.html
You can also find the source code for this example in the file storage/ndb/ndbapi-examples/ndbapi_basic/ndbapi_basic_insert.cpp.
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-blobs-ndbrecord.html
*/ void drop_table(MYSQL &mysql) { if (mysql_query(&mysql, "DROP TABLE api_blob_ndbrecord")) MYSQLERROR(mysql); } /* Functions to create table. */ char buffer[10000]; NdbTransaction *myTrans= myNdb->startTransaction(); if (myTrans == NULL) ... This ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-handling-errors.html
\n"; for (int i = 10000; i < 20000; i++) { executeInsertTransaction(i, myNdb, myTable); } std::cout << "Done.\n"; delete myNdb; delete cluster_connection; ndb_end(0); return 0; } . This program demonstrates handling errors and retrying failed ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Therefore, these functions should not be ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.4/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). row ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-unsupported.html
If a prefix is used as part of an index specification in a statement such as CREATE TABLE, ALTER TABLE, or CREATE INDEX, the prefix is not created by NDB. A statement containing an index prefix, and creating or modifying an NDB table, must still be ... A number of features supported by other storage engines are not supported for NDB ...Trying to use any of these features in NDB Cluster does not cause errors in or of itself; ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
For other examples showing how to use spatial data types in MySQL, see Section 13.4.6, “Creating Spatial Columns”. MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes-ndbrecord.html
*/ NdbDictionary::RecordSpecification spec[2]; spec[0].column= col1; spec[0].offset= offsetof(MyTableRow, attr1); // So that it goes nicely into the struct spec[0].nullbit_byte_offset= 0; spec[0].nullbit_bit_in_byte= 0; const NdbRecord *pk_record= ...*/ const NdbDictionary::Column *col1= myTable->getColumn("ATTR1"); if (col1 == NULL) APIERROR(myDict->getNdbError()); const NdbDictionary::Column *col2= myTable->getColumn("ATTR2"); if (col2 == NULL) APIERROR(myDict->getNdbError()); /* NdbRecord for primary key ...