Search Results
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or TIMESTAMP, and fsp is the fractional seconds precision. (This differs from the standard SQL default of 6, for ... The ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-optimization.html
The most important preconditions for using indexes for GROUP BY are that all GROUP BY columns reference attributes from the same index, and that the index stores its keys in order (as is true, for example, for a BTREE index, but not for a HASH ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-qualifiers.html
ON mydb.mytable ...; A column name may be given multiple qualifiers to indicate context in statements that reference it, as shown in the following table. Suppose that column c1 occurs only in table t1, c2 only in t2, and c in both t1 and t2. Suppose ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
Evaluation of statements that contain an ORDER BY clause and a different GROUP BY clause, or for which the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue. To determine whether a statement requires a ...
https://dev.mysql.com/doc/refman/8.4/en/known-issues.html
DISTINCT with ORDER BY does not work inside GROUP_CONCAT() if you do not use all and only those columns that are in the DISTINCT list. When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-hash.html
This can simply be the name of a column whose type is one of MySQL's integer types. You should be aware that, if a table has any unique keys, every column used in the partitioning expression for this table must be part of every unique key, including ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-summary-tables.html
row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 ... The ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-anomaly-detection-logs.html
The input table can only have the following columns: The column containing the logs. If including logs from different sources, a column containing the source of each log. The values in this column contain the names of the sources that each log ...
https://dev.mysql.com/doc/refman/8.4/en/charset-examples.html
Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE latin2_bin; Here we have a column with a latin1 character set and a latin1_german1_ci ... The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs. The value shown in this column reflects the addition or subtraction of any INTERVAL value included in the event's AT clause. For example, if an ...