PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or both. Making Delimited-Text File Backups ...Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
The binary log is not used for statements such as SELECT or SHOW that do not modify data. The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It also contains events for ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/charset-binary-set.html
The binary character set is the character set for binary strings, which are sequences of bytes. Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from ...
https://dev.mysql.com/doc/refman/8.0/en/charset-national.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; MySQL 8.0 interprets the national character set as utf8mb3, which is now deprecated. Standard SQL defines NCHAR or NATIONAL CHAR as a way to ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION statement: START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE type=1; COMMIT; With START ...SET ...
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
Because there is no such argument, mysql selects no default database. Only connection options that are relevant to the selected transport protocol are used or checked. This section describes use of command-line options to specify how to establish ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Remember that even a SELECT statement opens a transaction, so after running some report or debugging queries in an interactive mysql session, either issue a COMMIT or close the mysql session. Transferring Data To transfer a large volume of data into ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
This query displays the row in this table inserted by the statement just shown for creating the user jim@localhost: mysql> SELECT * FROM INFORMATION_SCHEMA.USER_ATTRIBUTES -> WHERE USER = 'jim' AND HOST = 'localhost'\G *************************** 1.
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. The number of columns retrieved by the SELECT statement must match the ...Cursor declarations must appear before handler declarations and after variable and condition ...