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/enum.html
Handling of Enumeration Literals Trailing spaces are automatically deleted from ENUM member values in the table definition when a table is created. An ENUM is a string object with a value chosen from a list of permitted values that are enumerated ...
https://dev.mysql.com/doc/refman/5.7/en/events-syntax.html
When a scheduled event is no longer wanted or needed, it can be deleted from the server by its definer using the DROP EVENT statement. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/5.7/en/explain-extended.html
SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and UPDATE). For SELECT statements, the EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be ...
https://dev.mysql.com/doc/refman/5.7/en/extended-show.html
If the IS_UPDATABLE value for a view has become inaccurate to due to changes to underlying views, the value can be updated by deleting and recreating the view. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-innodb-change-buffer.html
What types of operations modify secondary indexes and result in change buffering? INSERT, UPDATE, and DELETE operations can modify secondary indexes. What types of operations modify secondary indexes and result in change buffering? A.16.2. How much ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage engine. Which versions of the MySQL software support NDB Cluster? Do I have to compile from source? A.10.2. What is the difference between ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-triggers.html
Does MySQL have statement-level or row-level triggers? All triggers are FOR EACH ROW; that is, the trigger is activated for each row that is inserted, updated, or deleted. Where can I find the documentation for MySQL 5.7 triggers? A.5.2. Is there a ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of rows that were changed (affected), or to return the number of rows matched instead by setting a flag when connecting to the server. This section describes some of the important ...
https://dev.mysql.com/doc/refman/5.7/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...