PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-features-transactions.html
However, when a second connection updates the nontransactional table before the first connection transaction is complete, statements can be logged out of order because the second connection update is written immediately after it is performed, ...In ...
https://dev.mysql.com/doc/refman/9.7/en/reusing-ssl-sessions.html
For example, change the cache timeout value from the default (300 seconds) to 600 seconds: mysql> SET GLOBAL ssl_session_cache_timeout = 600; The members of each pair of system and status variables may have different values temporarily due to the ...
https://dev.mysql.com/doc/refman/9.7/en/select-optimization.html
Tuning these statements is a top priority, whether to achieve sub-second response times for dynamic web pages, or to chop hours off the time to generate huge overnight reports. With efficient use of the InnoDB buffer pool, MyISAM key cache, and the ... Queries, in the form of SELECT statements, perform all the lookup operations in the ...
https://dev.mysql.com/doc/refman/9.7/en/set-operations.html
FROM t2) ORDER BY sort_col; To maintain sort order within individual results, add a secondary column to the ORDER BY clause: (SELECT 1 AS sort_col, col1a, col1b, ... Result Set Column Names and Data Types Set Operations with TABLE and VALUES ...
https://dev.mysql.com/doc/refman/9.7/en/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
Table 27.3 Type Conversion: JavaScript Dates to MySQL JavaScript TypeMySQL DATEMySQL DATETIME, TIMESTAMPMySQL YEARnull or undefined NULL NULL NULL Date Retain value as is, rounding off any time part to the closest second. Timezones defined in the ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-examples.html
For example, for the vectors in the second row in table v2 ([100, 0, -50] and [5, 10, 5]), the dot product is (100)(5) + (0)(10) + (-50)(5) = 500 + 0 - 250 = 250. This section contains examples illustrating a number of different aspects of using ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-recommender.html
The first of these predicts ratings over a table and stores them in an output table, while the second predicts the rating of a single sample of data and returns the rating to the caller. The first predicts items over an entire table of users and ...
https://dev.mysql.com/doc/refman/9.7/en/string-comparison-functions.html
However, this is not the case: The second query returns 0. Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string ...
https://dev.mysql.com/doc/refman/9.7/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This variable has global and session values and can be changed at runtime. To see the current set of ...