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/windows-installation.html
Important MySQL Community 5.7 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows platforms. This requirement changed over time: MySQL 5.7.37 and below requires the Microsoft Visual C++ 2013 Redistributable ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. Its value is constructed from the User and Host columns of the user table row for the account. However, this value does not necessarily ...
https://dev.mysql.com/doc/refman/5.7/en/any-in-some-subqueries.html
The expression is TRUE if table t2 contains (21,14,7) because there is a value 7 in t2 that is less than 10. The expression is FALSE if table t2 contains (20,10), or if table t2 is empty. The expression is unknown (that is, NULL) if table t2 ...When ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
For example, if a table contains 'a', an attempt to store 'a ' causes a duplicate-key error. This is in contrast to all other data types, for which storage is allocated once per column when the table is opened. A BLOB is a binary large object that ...
https://dev.mysql.com/doc/refman/5.7/en/charset-cp932.html
The table shown at https://msdn.microsoft.com/en-us/goglobal/cc305152.aspx provides information about the Unicode values of cp932 characters. For cp932 table entries with characters under which a four-digit number appears, the number represents the ... Why is cp932 needed? In MySQL, the sjis character set corresponds to the Shift_JIS character set defined by IANA, which supports JIS X0201 and JIS X0208 ...
https://dev.mysql.com/doc/refman/5.7/en/charset-database.html
To see the default collation for each character set, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS table. To override this, provide explicit CHARACTER SET and COLLATE table options. Every database has a ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
For join queries, the number of possible plans investigated by the MySQL optimizer grows exponentially with the number of tables referenced in a query. For small numbers of tables (typically less than 7 to 10) this is not a problem. The behavior of ... The task of the query optimizer is to find an optimal plan for executing an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
The following example shows a simple stored procedure that, given a country code, counts the number of cities for that country that appear in the city table of the world database. This prohibition includes SELECT statements that do not have an INTO ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
Suppose that a customer table containing customer records has these columns: id: Customer ID number. Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to 6. (This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Any TIMESTAMP or ...