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/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It also contains events for statements that potentially could have made changes (for example, a DELETE which matched no ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
Table 12.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. They ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at https://dev.mysql.com/doc/. We try to keep the manual up to date by updating ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 authentication. caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/5.7/en/call.html
CALL sp_name([parameter[,...]]) CALL sp_name[()] The CALL statement invokes a stored procedure that was defined previously with CREATE PROCEDURE. Stored procedures that take no arguments can be invoked without parentheses. CALL can pass back values ...
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port number. A Unix ...
https://dev.mysql.com/doc/refman/5.7/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data ...