PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/view-check-option.html
The check for v3 fails as before: mysql> INSERT INTO v2 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v2' mysql> INSERT INTO v3 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v3' . The WITH CHECK OPTION clause can be given ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
The database structures are organized into physical files optimized for speed. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or ... MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
They are often used with a GROUP BY clause to group values into subsets. This section describes aggregate functions that operate on sets of values. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated to replica servers. Inserts are performed into the source's table without explicitly setting the ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/cache-index.html
After the indexes have been assigned, they can be preloaded into the cache if desired with LOAD INDEX INTO CACHE. For more information, see Section 13.7.6.5, “LOAD INDEX INTO CACHE Statement”. | tbl_name PARTITION (partition_list) } IN ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-effect.html
The second column shows the result of the SELECT using the German DIN-1 rule, which says that U-umlaut sorts with U. The third column shows the result of the SELECT using the German DIN-2 rule, which says that U-umlaut sorts with UE.
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16.html
For example, since U+F8FF is the Apple Logo, this is legal: INSERT INTO t (utf16_column)VALUES (0xf8ff); /* legal */ Such characters cannot be expected to mean the same thing to everyone. The utf16 character set is the ucs2 character set with an ...
https://dev.mysql.com/doc/refman/5.7/en/checking-rpm-signature.html
To import the MySQL public key into the RPM keyring, first obtain the key, then use rpm --import to import the key. RPM 4.1 no longer uses your personal GPG keyring (or GPG itself). Rather, RPM maintains a separate keyring because it is a ...