Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework-core-scaffold-example.html
The resulting entities are created and mapped to the tables in the specified database. For an overview of the requirements to use EF Core with MySQL, see Table 7.1, “Connector/NET Versions and Entity Framework Core Support”). Additional ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
The applications do not need to hardcode table and column names, complicated queries, and so on. When security is paramount, stored procedures keep applications from directly manipulating tables, or even knowing details such as table and column ...
https://dev.mysql.com/doc/internals/en/com-query-response.html
Note Not all Table Column Types have a representation in the Text or Binary protocol. Image description If it is not a valid Protocol::LengthEncodedInteger it is either a ERR_Packet or a Protocol::LOCAL_INFILE_Request. Image description 14.6.4.1.1 ...
https://dev.mysql.com/doc/internals/en/logging-transactions-definitions.html
To reason about logging different table types, we make some preliminary definitions. (D-T-table) A table that has a transactional engine is called a T-table. (D-N-table) A table that has a nontransactional engine is called an N-table. Note: ...
https://dev.mysql.com/doc/internals/en/open.html
For instance when a request comes in for a select on the table (tables are not open and closed for each request, they are cached). The server opens all tables by calling ha_open() which then calls the handler specific open(). The first parameter is ...Synopsis virtual int open ( name, mode, test_if_locked); const char * name ; int mode ; uint test_if_locked ; Description This is the open ...
https://dev.mysql.com/doc/internals/en/select-union.html
We will need this object to store in every JOIN structure link on it, but we have not (yet) temporary table structure. Create a temporary table for storing union results (if UNION without ALL option, 'distinct' parameter will be passed to the table ...Allocate JOIN structures and execute JOIN::prepare() for every SELECT to get full information about types of elements of SELECT list ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-clusterjhelper.html
Table 4.8 getServiceInstance(Class<T>) Parameter Description cls the class of the factory return the service instance 4.3.1.8.4 getServiceInstance(Class<T>, ClassLoader) public static T getServiceInstance(Class<T> cls, ClassLoader loader); Locate a ... ClusterJHelper provides helper methods to bridge between the API and the ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-query-predicateoperand.html
Table 4.104 between(PredicateOperand, PredicateOperand) Parameter Description lower another PredicateOperand upper another PredicateOperand return a new Predicate 4.3.3.2.3 equal(PredicateOperand) public abstract Predicate equal(PredicateOperand ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-metric-mysqlserver-ddlstatementactivity-category.html
Table 8.3 DDL Statement Activity Metrics Target NameName of the OEM TargetAlter DB (Delta) The total number of ALTER DATABASE statements executed. Alter Table (Delta) The total number of ALTER TABLE statements executed. Alter Tablespace (Delta) The ... Lists the DDL Statement Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Buffer Result Enabled If set to 1, sql_buffer_result forces results from SELECT statements to be put into temporary tables. This helps MySQL free the table locks early and can be beneficial in cases where it takes a long time to send results to the ... Lists the Statement Processing configuration metrics and provides a brief description of ...