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-installation.html
Obtain and Unpack the Distribution Pick the directory under which you want to unpack the distribution and change location into it. These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
Rows are stored into the binary log in chunks having a size in bytes not exceeding the value of this option. You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for type ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
For example, if you are using InnoDB tables and the MySQL server processes a COMMIT statement, it writes many prepared transactions to the binary log in sequence, synchronizes the binary log, and then commits this transaction into InnoDB. The ...
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
Truncation of excess trailing spaces from values to be inserted into TEXT columns always generates a warning, regardless of the SQL mode. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
(Even the lettercase should be observed.) It is best to copy and paste the entire error message into your report. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
The client-side plugin is built into the libmysqlclient client library and is available to any program linked against libmysqlclient. MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 VALUES(2000,1,1),(2000,1,20),(2000,1,30),(2000,2,2), (2000,2,23),(2000,2,23); The example table contains year-month-day values representing visits by users to the page. 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 ...
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 ...