Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-getschema.html
The schema information is returned in the form of a DataTable. The following are the collections currently provided by Connector/NET, in addition to the common collections shown previously: Databases Tables Columns Users Foreign Keys IndexColumns ...
https://dev.mysql.com/doc/connector-net/en/connector-net-simple-membership-tutorial.html
<membership defaultProvider="MySqlSimpleMembershipProvider"> <providers> <clear/> <add name="MySqlSimpleMembershipProvider" type="MySql.Web.Security.MySqlSimpleMembershipProvider,MySql.Web, ... This section documents the ability to use a simple ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-export.html
Important Make sure that the information that you are exporting to the MySQL table is valid for the corresponding MySQL data types. Right click on the table you want to export, and in the menu that appears, choose Export , ODBC Database. Enter the ...Values that are valid within Access but are outside of the supported ranges of the MySQL data types may trigger an “overflow” error during the ...
https://dev.mysql.com/doc/internals/en/creating-handlerton.html
The handlerton (short for handler singleton) defines the storage engine and contains method pointers to those methods that apply to the storage engine as a whole, as opposed to methods that work on a per-table basis. This is the name that will be ...Some examples of such methods include transaction methods to handle commits and ...
https://dev.mysql.com/doc/internals/en/differences-master-slave.html
Any intermediate state of the slave is identical to some intermediate state of the master. Note: it is not required that each intermediate state of the master is identical to some intermediate state of the slave. We now state the architectural ...
https://dev.mysql.com/doc/internals/en/implementing-the-info-method.html
The optimizer requests an update of table information by calling the [custom-engine.html#custom-engine-api-reference-info handler::info()] method. These values are also used to populate certain SHOW outputs such as SHOW TABLE STATUS and for queries ...The info() method does not have a return value, instead it is expected that the storage engine will set a variety of public variables that the server will then read as ...
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
A join buffer is never allocated for the first non-const table, even if it would be of type ALL or index. The buffer is allocated when we need to do a full join between two tables, and freed after the query is done. Accepted row combinations of ...
https://dev.mysql.com/doc/internals/en/myisam-directory.html
They are: mi_cache.c --- for reading records from a cache mi_changed.c --- a single routine for setting a "changed" flag (very short) mi_check.c --- for checking and repairing tables. Can be used to exactly replay a set of changes to a table.
https://dev.mysql.com/doc/internals/en/optimizer-determining-join-type.html
index: a sequential scan on an index ALL: a sequential scan of the entire table See: /sql/sql_select.h, enum join_type{}. For example, consider this query: SELECT * FROM Table1 WHERE indexed_column = 5 AND unindexed_column = 6 Since indexed_column ... When evaluating a conditional expression, MySQL decides what join type the expression ...
https://dev.mysql.com/doc/internals/en/rows-event.html
repeat rows until event-end Fields table_id (6) -- If the table id is 0x00ffffff it is a dummy event that should have the end of statement flag set that declares that all table maps can be freed. Note if the post_header_length in the ...