Search

Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 255.8Kb
Man Pages (Zip) - 360.8Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb


Displaying 801 to 810 of 996 total 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/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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-views.html
Can you insert into views that are based on joins? It is possible, provided that your INSERT statement has a column list that makes it clear there is only one table involved. What happens to a view if an underlying table is dropped or renamed? A.6.4. Can you insert into views that are based on joins? ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE part. Note The syntax of the CASE operator described here differs ...
Displaying 801 to 810 of 996 total results