PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-literal.html
This is true even for the second string; the _latin1 introducer does not affect escape processing. Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16.html
This is called the “surrogate” mechanism: For a number greater than 0xffff, take 10 bits and add them to 0xd800 and put them in the first 16-bit word, take 10 more bits and add them to 0xdc00 and put them in the next 16-bit word. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/charset.html
This chapter discusses the following topics: What are character sets and collations? The multiple-level default system for character set assignment. MySQL includes character set support that enables you to store data using a variety of character ...
https://dev.mysql.com/doc/refman/5.7/en/choosing-types.html
Of the types that represent all the required values, this type uses the least amount of storage. This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary. For optimum storage, ...
https://dev.mysql.com/doc/refman/5.7/en/commands-out-of-sync.html
If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you ...
https://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html
WHERE 'a' = (SELECT column1 FROM t1) MySQL also permits this construct: non_subquery_operand LIKE (subquery) At one time the only legal place for a subquery was on the right side of a comparison, and you might still find some old DBMSs that insist ... The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup operation. However, this cannot be used if you are going to manipulate the database using processes external to the server while you hold ...If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/connection-management.html
This includes a description of the available connection interfaces, how the server uses connection handler threads, details about the administrative connection interface, and management of DNS lookups.
https://dev.mysql.com/doc/refman/5.7/en/correlated-subqueries.html
WHERE column1 = ANY (SELECT column1 FROM t2) would be TRUE, but in this example, the WHERE clause within the subquery is FALSE (because (5,6) is not equal to (5,7)), so the expression as a whole is FALSE. For example: SELECT column1 FROM t1 AS x ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
CREATE [AGGREGATE] FUNCTION function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named function_name. This directory is given by the value of the plugin_dir system variable.