Search Results
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/charsets.html
Character sets are recorded against individual tables and returned as part of the field data. You can obtain a list of the available character sets configured within a server by running SHOW COLLATION, or by running a query on the ... Character sets ...
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/mysqld-version-reference/en/sys-schema-objects.html
The following tables show all sys schema objects available in MySQL Server. An item has a row in the table if it ever existed in any series shown in the table. Introduced: The version or versions in which the item was introduced. Deprecated: The ...
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/ndbapi/en/mccj-using-clusterj-operations.html
To insert a new row into the table, first create a new instance of Employee. This can be accomplished by calling the Session method newInstance(), as shown here: Employee newEmployee = session.newInstance(Employee.class); Set the Employee instance ...For example, the following sets the id, firstName, lastName, and started ...