PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-functions.html
TIME if the date argument is a TIME value and the calculations involve only HOURS, MINUTES, and SECONDS parts (that is, no date parts). DATETIME if the first argument is a DATETIME (or TIMESTAMP) value, or if the first argument is a DATE and the ...
https://dev.mysql.com/doc/refman/9.7/en/expressions.html
unit represents the unit for interpreting the quantity; it is a specifier such as HOUR, DAY, or WEEK. For example, if you specify a unit of DAY_SECOND, the value of expr is expected to have days, hours, minutes, and seconds parts. If you specify a ... This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in ...
https://dev.mysql.com/doc/refman/9.7/en/user-resources.html
The value for each per-hour limit should be an integer representing a count per hour. The following statement changes the query limit for francis to 100: mysql> ALTER USER 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100; The statement modifies ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
This is an example of a minimal CREATE EVENT statement: CREATE EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE myschema.mytable SET mycol = mycol + 1; The previous statement creates an event named myevent. This event ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-system-variables.html
You can specify a timeout value up to a maximum of 3600 seconds (1 hour). The group_replication_member_expel_timeout system variable determines the waiting period (up to an hour) that is allowed in addition to the initial 5-second detection period ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/9.7/en/alter-event.html
The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as when used with CREATE EVENT. (See Section 15.1.15, “CREATE EVENT Statement”.) Any user can alter an event defined on ...
https://dev.mysql.com/doc/refman/9.7/en/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 digits) ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-literals.html
Similarly, for values specified as strings that include time part delimiters, it is unnecessary to specify two digits for hour, minute, or second values that are less than 10. The string is interpreted from left to right to find year, month, day, ...
https://dev.mysql.com/doc/refman/9.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-resource-manager-component.html
The default length of the quarantine period is 3600 seconds (1 hour). The Group Replication Resource Manager component monitors secondary server lag time and memory usage, and can expel servers which lag excessively or use too many resources from ...