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/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns.
https://dev.mysql.com/doc/refman/5.7/en/create-table-select.html
SELECT, make sure to alias any function calls or expressions in the query. You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
Within a trigger body, the CURRENT_USER function returns the account used to check privileges at trigger activation time. CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
MySQL provides functions for doing date arithmetic, so this is not difficult. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
When the server operates in bootstrap mode, some functionality is unavailable that limits the statements permitted in the file. After MySQL is installed, the data directory must be initialized, including the tables in the mysql system database: For ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-conversion.html
To perform the comparison by ignoring the time part of the DATETIME value instead, use the CAST() function in the following way: date_col = CAST(datetime_col AS DATE) Conversion of TIME and DATETIME values to numeric form (for example, by adding +0) ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-type-syntax.html
The SUM() and AVG() aggregate functions do not work with temporal values. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the DATE and DATETIME range descriptions, “supported” ...
https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html
Thus, it is possible for this file not to be present on a MySQL server that is functioning in a completely normal manner. The DDL log, or metadata log, records metadata operations generated by data definition statements affecting table ...