Search Results
https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html
Preparing a Microsoft Access Database for Migration Microsoft Access stores relationship/foreign key information in an internal table called MSysRelationships. That table is protected against read access even to the Admin user, so if you try to ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method. getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-access-import.html
To import tables from MySQL to Access, follow these instructions: Open the Access database into which that you want to import MySQL data. Figure 5.18 External Data: ODBC Database In the Get External Data dialog box that appears, choose Import the ...Figure 5.19 Get External Data: ODBC Database The Select Data Source dialog box ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-import.html
To import tables from MySQL to Access, follow these instructions: Open the Access database into which that you want to import MySQL data. Figure 6.7 External Data: ODBC Database In the Get External Data dialog box that appears, choose Import the ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
Include a TIMESTAMP column in all tables that you want to be able to update. Include a primary key in each MySQL table you want to use with Access. If you are using Connector/ODBC to link to a table that has a BIGINT column, the results are ... To ...
https://dev.mysql.com/doc/internals/en/event-meanings.html
XID_EVENT Generated for a commit of a transaction that modifies one or more tables of an XA-capable storage engine. It maps a table definition to a number, where the table definition consists of database and table names and column definitions. The ... The following descriptions briefly summarize the meaning of each event type: UNKNOWN_EVENT This event type should never ...
https://dev.mysql.com/doc/internals/en/guided-tour-chunk.html
if (updated && (error <= 0 || !transactional_table)) { mysql_bin_log.write(&qinfo) && transactional_table); ... Incidentally, a transactional table is usually a BDB or an InnoDB table. Now, having finished with our bird's eye view of the source ...
https://dev.mysql.com/doc/internals/en/the-myi-file.html
A .MYI file for a MyISAM table contains the table's indexes. We are going to use an example table throughout the description. (There can be space truncation if keyseg->flag HA_SPACE_PACK flag is on.) For fixed-row tables: The pointer is a ...The ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-dbug.html
Table 4.28 append(String) Parameter Description fileName the name of the file return this 4.3.1.15.3 debug(String) public abstract Dbug debug(String string); Set the list of debug keywords. Table 4.29 debug(String) Parameter Description string the ... Dbug allows clusterj applications to enable the DBUG functionality in cluster ndbapi ...
https://dev.mysql.com/doc/ndbapi/en/ndb-start-mysql-db-object-names.html
Instead, they are modelled as attributes of Table and Index objects. The value of the database attribute of one of these objects is always the same as the name of the MySQL database to which the table or index belongs. The value of the schema ...