Search Results
https://dev.mysql.com/doc/connector-python/en/connector-python-api-fieldtype.html
The field type is stored with every cursor in the description for each column. The following example shows how to print the name of the data type for each column in a result set. This class provides all supported MySQL field or data types. They can ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
The AUTO_INCREMENT column option for the primary key of the employees table is important to ensure reliable, easily searchable data. The query to insert the new employee is executed and we retrieve the newly inserted value for the emp_no column (an ... Inserting or updating data is also done using the handler structure known as a ...
https://dev.mysql.com/doc/internals/en/binary-protocol-resultset-row.html
A Binary Protocol Resultset Row is made up of the NULL bitmap containing as many bits as we have columns in the resultset + 2 and the values for columns that are not NULL in the Binary Protocol Value format. ProtocolBinary::ResultsetRow: row of a ...
https://dev.mysql.com/doc/internals/en/index-file-usage.html
These are the number of columns of the table and the length of each column. The latter is required for columns with suppressed leading spaces or suppressed trailing spaces or zeros. While the header of the compressed data file contains a lot of ...
https://dev.mysql.com/doc/internals/en/optimizer-eliminating-dead-code.html
A transformation takes place for conditions that are always true, for example: WHERE 0=0 AND column1='y' In this case, the first condition is removed, leaving WHERE column1='y' See: /sql/sql_select.cc, remove_eq_conds(). If a column cannot be NULL, ...A transformation also takes place for conditions that are always ...
https://dev.mysql.com/doc/internals/en/optimizer-index-join-type.html
Consider this query: SELECT column1 FROM Table1; If column1 is indexed, then the optimizer may choose to retrieve the values from the index rather than from the table. For this query: SELECT column1, column2 FROM Table1; the optimizer will use join ...An index which is used this way is called a covering index in most ...
https://dev.mysql.com/doc/internals/en/too-greedy-test.html
--replace_column 15 <CREATE_TIME> 16 <UPDATE_TIME> 17 <CHECK_TIME> SELECT * FROM information_schema.tables; The SELECT above makes the test extreme "greedy" for changes in behaviour which is maybe good for general bug hunting but not for smart and ... Let's assume we have to check that every new created table causes a row in ...
https://dev.mysql.com/doc/mysqld-version-reference/en/build-options.html
The following table details the CMake configuration options available when building MySQL Server from source. Introduced: The version or versions in which the item was introduced. Removed: The version or versions in which the item was removed.
https://dev.mysql.com/doc/ndbapi/en/ndb-datafile.html
Datafile Class Overview Datafile Class Constructor Datafile::getFileNo() Datafile::getFree() Datafile::getNode() Datafile::getObjectId() Datafile::getObjectStatus() Datafile::getObjectVersion() Datafile::getPath() Datafile::getSize() ... This ...
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).