Search Results
https://dev.mysql.com/doc/internals/en/opening-a-table.html
Before any read or write operations are performed on a table, the MySQL server will call the [custom-engine.html#custom-engine-api-reference-open handler::open()] method to open the table data and index files (if they exist). int open(const char ...
https://dev.mysql.com/doc/internals/en/starting-transaction-from-external-lock-method.html
MySQL calls [custom-engine.html#custom-engine-api-reference-external_lock handler::external_lock()] for every table it is going to use at the beginning of every statement. Thus, if a table is touched for the first time, it implicitly starts a ...
https://dev.mysql.com/doc/internals/en/support-for-update.html
Performing an update will depend on row format and storage implementation. Some storage engines will replace data in-place, while other implementations delete the existing row and append the new row at the end of the data file. Non-indexed storage ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
This section describes how to import tables using the Transportable Tablespaces feature, which permits importing tables, partitioned tables, or individual table partitions that reside in file-per-table tablespaces. There are many reasons why you ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-postgresql-typemapping.html
The following table shows the mapping between PostgreSQL (source) data types and MySQL data types. Table 10.3 Type mapping Source Type MySQL Type Comment INT INT SMALLINT SMALLINT BIGINT BIGINT SERIAL INT Sets AUTO_INCREMENT in its table definition. BIT BIT BOOLEAN TINYINT(1) REAL FLOAT DOUBLE PRECISION DOUBLE NUMERIC DECIMAL DECIMAL DECIMAL MONEY DECIMAL(19,2) CHAR CHAR/LONGTEXT Depending on its ...
https://dev.mysql.com/doc/connectors/en/connector-j-source-replica-replication-connection.html
This section describe a number of features of Connector/J's support for replication-aware deployments. Such Connection objects report they are read-only, and isSourceConnection() returns false for them. The Connection tests for available source ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-statements-callable.html
For more information on MySQL stored procedures, please refer to Using Stored Routines. Notice that you have to use JDBC escape syntax, and that the parentheses surrounding the parameter placeholders are not optional: Example 3.7 Connector/J: Using ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
This tutorial teaches you how to use the MySqlScript class. Depending on the circumstances, this can be more convenient than using the MySqlCommand approach. Further details of the MySqlScript class can be found in the reference documentation ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET. 5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#.
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-apptips-microsoft.html
The majority of Microsoft applications have been tested with Connector/ODBC, including Microsoft Office, Microsoft Access and the various programming languages supported within ASP and Microsoft Visual Studio. 5.8.2.1.1 Microsoft Access To improve ...