PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
MySQL permits you to store dates where the day or month and day are zero in a DATE or DATETIME column. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. Each temporal type has a range of ...
https://dev.mysql.com/doc/refman/5.7/en/declare-cursor.html
The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH statement. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
Consider the following query: SELECT * FROM t1 JOIN (SELECT DISTINCT f1 FROM t2) AS derived_t2 ON t1.f1=derived_t2.f1; The optimizer constructs an index over column f1 from derived_t2 if doing so would enable use of ref access for the lowest cost ...
https://dev.mysql.com/doc/refman/5.7/en/describe.html
For more information, see Section 13.7.5.5, “SHOW COLUMNS Statement”, and Section 13.8.2, “EXPLAIN Statement”. The DESCRIBE and EXPLAIN statements are synonyms, used either to obtain information about table structure or query execution ...
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
CATALOG_NAME, SCHEMA_NAME, TABLE_NAME, COLUMN_NAME: Strings that indicate the catalog, schema, table, and column related to the condition. SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
This differs from working with a relational database and storing products in a table, when all columns of the table must be known and defined before adding any products to the database. This chapter introduces an alternative way of working with ...
https://dev.mysql.com/doc/refman/5.7/en/drop-index.html
To drop a primary key, the index name is always PRIMARY, which must be specified as a quoted identifier because PRIMARY is a reserved word: DROP INDEX `PRIMARY` ON t; Indexes on variable-width columns of NDB tables are dropped online; that is, ...
https://dev.mysql.com/doc/refman/5.7/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/5.7/en/execution-plan-information.html
Depending on the details of your tables, columns, indexes, and the conditions in your WHERE clause, the MySQL optimizer considers many techniques to efficiently perform the lookups involved in an SQL query. A query on a huge table can be performed ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-information-schema.html
However, Oracle and MySQL use different table names and column names. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Where can I find the ANSI SQL 2003 specification for INFORMATION_SCHEMA? A.7.4. What is the ...