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/faqs-views.html
What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. What happens to a view if an underlying table is dropped or renamed? ...Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-upgrade-downgrade-7-5.html
When upgrading a previous release to NDB 7.5 (or later), you can use the --force --upgrade-system-tables options with mysql_upgrade so that it performs ALTER TABLE ... The table shown here provides information on NDB Cluster upgrade and downgrade ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For TEMPTABLE, the results from the view are retrieved into a temporary table, which then is used to execute the statement. It prefers MERGE over ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
Password Expiration Policy To expire an account password manually, use the ALTER USER statement: ALTER USER 'jeffrey'@'localhost' PASSWORD EXPIRE; This operation marks the password expired in the corresponding mysql.user system table row. To ...For ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-disk-data.html
It is possible to store the nonindexed columns of NDB tables on disk, rather than in RAM. As part of implementing NDB Cluster Disk Data work, a number of improvements were made in NDB Cluster for the efficient handling of very large amounts ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam.html
The MyISAM storage engine performs best with read-mostly data or with low-concurrency operations, because table locks limit the ability to perform simultaneous updates. In MySQL, InnoDB is the default storage engine rather than MyISAM.
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
You can do this by storing in a separate table the event names from the SELECT statement shown previously, or using ALTER EVENT statements to rename the events with a common prefix such as replicated_ to identify them. The following statements are ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...
https://dev.mysql.com/doc/refman/5.7/en/crashing.html
In this case, you can try to change the storage engine to another engine by using ALTER TABLE on a repaired copy of the table. If you have a problem with tables containing dynamic-length rows and you are using only VARCHAR columns (not BLOB or TEXT ...The preceding means that normally you should not get corrupted tables unless one of the following happens: The MySQL server or the server host was killed in the middle of an ...