Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-known-issues-limitations.html
The following are some known issues and limitations for MySQL Connector/J: When Connector/J retrieves timestamps for a daylight saving time (DST) switch day using the getTimeStamp() method on the result set, some of the returned values might be ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, ...
https://dev.mysql.com/doc/internals/en/date-and-time-data-type-representation.html
The following table shows the storage requirements for date and time data types. Storage for these types is big endian (for memcmp() compatibility purposes), with the nonfractional part followed by the fractional part. FSP Storage 0 0 bytes 1,2 1 ...
https://dev.mysql.com/doc/internals/en/optimizer-constant-propagation.html
Probably they should not apply for LIKE either, but that's a story for another day. Constant propagation happens in a loop, so the output from one propagation step can be input for the next step.
https://dev.mysql.com/doc/internals/en/query-event.html
Binlog::QUERY_EVENT: The query event is used to send text querys right the binlog. Post-header 4 slave_proxy_id 4 execution time 1 schema length 2 error-code if binlog-version ≥ 4: 2 status-vars length Payload string[$len] status-vars ...
https://dev.mysql.com/doc/internals/en/transactions-historical-note.html
"Statement transaction" is a non-standard term that comes from the days when MySQL supported the BerkeleyDB storage engine. First, observe that in BerkeleyDB the "auto-commit" mode causes automatic commit of operations that are atomic from the ...
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
When a new connection is established, thd->transaction members are initialized to an empty state. If a statement uses any tables, all affected engines are registered in the statement engine list. In non-autocommit mode, the same engines are ...
https://dev.mysql.com/doc/mysqld-version-reference/en/built-in-functions.html
The following table shows all built-in functions and operators available in MySQL Server. Introduced: The version or versions in which the item was introduced. Deprecated: The version or versions in which the item was deprecated. Removed: The ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-5-7.html
This section provides information about keywords and reserved words in MySQL 5.7. MySQL 5.7 Keywords and Reserved Words MySQL 5.7 New Keywords and Reserved Words MySQL 5.7 Removed Keywords and Reserved Words MySQL 5.7 Keywords and Reserved Words ...