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/date-calculations.html
To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. DATE_ADD() enables you to add a time interval to a given date. MySQL provides several functions that you can use to perform calculations on dates, for example, ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
Creating a table with these columns with an explicit ROW_FORMAT clause does not raise an error or warning; the format specification is ignored. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Of the ...
https://dev.mysql.com/doc/refman/5.7/en/program-options.html
This is common for options that you want the program to use each time it runs. This method is useful for options that you want to apply each time the program runs. Options are processed in order, so if an option is specified multiple times, the last ... There are several ways to specify options for MySQL programs: List the options on the command line following the program ...
https://dev.mysql.com/doc/refman/5.7/en/concurrent-inserts.html
With LOAD DATA, if you specify CONCURRENT with a MyISAM table that satisfies the condition for concurrent inserts (that is, it contains no free blocks in the middle), other sessions can retrieve data from the table while LOAD DATA is executing. Use ...If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-tables.html
To obtain global and per-session statement execution counts, use the events_statements_summary_global_by_event_name and events_statements_summary_by_thread_by_event_name tables, respectively. If the performance_schema_max_thread_instances system ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-virtual-table.html
The INNODB_SYS_VIRTUAL table provides metadata about InnoDB virtual generated columns and columns upon which virtual generated columns are based, equivalent to information in the SYS_VIRTUAL table in the InnoDB data dictionary. A row appears in the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-summary-tables.html
Note The value of the show_compatibility_56 system variable affects the information available from the tables described here. For details, see the description of that variable in Section 5.1.7, “Server System Variables”. The Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent I/O error took place. replication_connection_status Column SHOW SLAVE STATUS Column SOURCE_UUID Master_UUID THREAD_ID None SERVICE_STATE Slave_IO_Running ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-memory.html
If TMPDIR points to a memory file system, out of memory errors can easily occur. myisamchk uses no more memory than its memory-related variables are set to. If you are going to use myisamchk on very large tables, you should first decide how much ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
To ensure that a given DELETE statement does not take too much time, the MySQL-specific LIMIT row_count clause for DELETE specifies the maximum number of rows to be deleted. Given a partitioned table t with a partition named p0, executing the ...