Search Results
https://dev.mysql.com/doc/connectors/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/connector-net/en/connector-net-8-0-connection-options.html
SslCert , Ssl-Cert Default: null The name of the SSL certificate file in PEM format to use for establishing an encrypted connection. SslKey , Ssl-Key Default: null The name of the SSL key file in PEM format to use for establishing an encrypted ...
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/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 ...