Search Results
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-export.html
Important Make sure that the information that you are exporting to the MySQL table is valid for the corresponding MySQL data types. Right click on the table you want to export, and in the menu that appears, choose Export , ODBC Database. Enter the ...Values that are valid within Access but are outside of the supported ranges of the MySQL data types may trigger an “overflow” error during the ...
https://dev.mysql.com/doc/internals/en/creating-handlerton.html
The handlerton (short for handler singleton) defines the storage engine and contains method pointers to those methods that apply to the storage engine as a whole, as opposed to methods that work on a per-table basis. This is the name that will be ...Some examples of such methods include transaction methods to handle commits and ...
https://dev.mysql.com/doc/internals/en/differences-master-slave.html
Any intermediate state of the slave is identical to some intermediate state of the master. Note: it is not required that each intermediate state of the master is identical to some intermediate state of the slave. We now state the architectural ...
https://dev.mysql.com/doc/internals/en/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.
https://dev.mysql.com/doc/internals/en/optimizer-determining-join-type.html
index: a sequential scan on an index ALL: a sequential scan of the entire table See: /sql/sql_select.h, enum join_type{}. For example, consider this query: SELECT * FROM Table1 WHERE indexed_column = 5 AND unindexed_column = 6 Since indexed_column ... When evaluating a conditional expression, MySQL decides what join type the expression ...
https://dev.mysql.com/doc/internals/en/scripts-directory.html
Can be safely run during any upgrade to get the newest MySQL privilege tables mysql_install_db.sh --- Create privilege tables and func table mysql_secure_installation.sh --- Disallow remote root login, eliminate test, etc. mysql_setpermission.sh --- ...Linux programmers use it where Windows programmers would use a *.bat (batch filename ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-constants.html
4.3.1.14.19 DEFAULT_PROPERTY_MGM_STRICT_TLS public static final int DEFAULT_PROPERTY_MGM_STRICT_TLS = 0; The default value of the MGM TLS level property 4.3.1.14.20 DEFAULT_PROPERTY_TABLE_WAIT_MSEC public static final int ...The default means that ...
https://dev.mysql.com/doc/ndbapi/en/mgm-errors.html
Table 3.9 Node ID allocation errors resulting from failure to assign a node ID Value Description NDB_MGM_ALLOCID_ERROR Generic error; may be possible to retry and recover NDB_MGM_ALLOCID_CONFIG_MISMATCH Non-recoverable generic error ... This section ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-secondary-indexes-ndbrecord.html
*/ 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 ... This program illustrates how to use secondary indexes in the NDB API with the aid of the NdbRecord ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbindexoperation.html
When the NdbTransaction::execute() method is invoked, the operation deletes a tuple from the table. When the NdbTransaction::execute() method is invoked, the operation updates a tuple found in the table. NdbIndexOperation Class Overview ...