Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-sql-command.html
When a connection has been established with the MySQL database, the next step enables you to perform database operations. This task can be achieved through the use of the MySqlCommand object. Results are usually returned in a MySqlDataReader ...
https://dev.mysql.com/doc/internals/en/optimizer-partition-pruning.html
Therefore its implementation is a part of the MySQL Query Optimizer. Now we look at how MySQL extracts intervals from arbitrary WHERE clauses. The extraction process uses the Range Analyzer — a part of the MySQL optimizer that produces plans for ...Partitions that did not get into this set (that is, those that were pruned away) will not be accessed at all: this is how query execution is made ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. MySQL Server 5.6 and higher can ...SMALLINT SMALLINT BIGINT BIGINT BIT TINYINT(1) FLOAT FLOAT Precision value is used for storage size in ...
https://dev.mysql.com/doc/internals/en/guided-tour-chunk.html
Now, having finished with our bird's eye view of the source code from the air, let's take the perspective of the worms on the ground (which is another name for MySQL's developer staff -- turn on laugh track here). if (updated && (error <= 0 || ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
You can use this routine for generating and running SQL queries only for databases and tables that you have access to. schemas: specifies the databases to consider for generating and running SQL queries. tables: specifies the tables to consider for ...The routine also runs the generated SQL statement and displays the result ...By default, databases that the ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html
As for the destination MySQL server, you can have it in the same local machine or elsewhere in your network. (-1907) (SQLExecDirectW) The steps to grant read access to the Admin role (using Microsoft Access 2007) are summarized as follows: Open up ...General Information Microsoft Windows is required because Microsoft Access ODBC drivers are only available on ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-nl-sql.html
You can use this routine for generating and running SQL queries only for databases and tables that you have access to. schemas: specifies the databases to consider for generating and running SQL queries. tables: specifies the tables to consider for ...The routine also runs the generated SQL statement and displays the result ...By default, databases that the ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-statements.html
Statement objects allow you to execute basic SQL queries and retrieve the results through the ResultSet class, which is described later. Once you have a Statement instance, you can execute a SELECT query by calling the executeQuery(String) method ...To create a Statement instance, you call the createStatement() method on the Connection object you have retrieved using one of the DriverManager.getConnection() or DataSource.getConnection() methods described ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-schema-error.html
The following list enumerates all NDB errors of type SE (Schema error).
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
MySQL monitors index searches for InnoDB tables, and if queries could benefit from a hash index, it builds one automatically for index pages that are frequently accessed. Connector/C++ Connector/C++ 8.0 can be used to access MySQL servers that ...