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/replication-implementation.html
Replication is based on the replication source server keeping track of all changes to its databases (updates, deletes, and so on) in its binary log. Tables are created or their structure modified, and data is inserted, deleted, and updated ...The ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
For example, if the user table grants you the DELETE privilege, you can delete rows from any table in any database on the server host. After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue ...
https://dev.mysql.com/doc/refman/5.7/en/reset.html
The following list describes the permitted RESET statement reset_option values: RESET MASTER Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. Also resets the relay log ...reset_option: { MASTER | QUERY CACHE | SLAVE } The RESET statement is used to clear the state of various server ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL Account”. If you know the root ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser does not seem quite right. Consulting your original pedigree papers, you find that the correct birth year should be 1989, not 1979. Fix only the erroneous record with an UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
If you delete or rename the table, the files that its symbolic links point to also are deleted or renamed. When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/5.7/en/show-table-status.html
Even with file-per-table mode with each InnoDB table in a separate .ibd file, change buffering can delay the write to the data file, so the file modification time is different from the time of the last insert, update, or delete. Update_time displays ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified). SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. Using prepared ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
Reorganization is unnecessary unless you delete a huge number of rows and want to return free disk space to the operating system. The expected row length in bytes for static-sized rows is calculated using the following expression: row length = 1 + ...It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or ...