MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 341 to 350 of 359 total results

15.2.14 Set Operations with UNION, INTERSECT, and EXCEPT

https://dev.mysql.com/doc/refman/8.0/en/set-operations.html

Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...

15.7.7.5 SHOW COLUMNS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-columns.html

The data types may differ from what you expect them to be based on a CREATE TABLE statement because MySQL sometimes changes data types when you create or alter a table. SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} ...

15.7.7.7 SHOW CREATE EVENT Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-event.html

For example (using the same event e_daily defined and then altered in Section 15.7.7.18, “SHOW EVENTS Statement”): mysql> SHOW CREATE EVENT myschema.e_daily\G *************************** 1. SHOW CREATE EVENT event_name This statement displays ...

15.7.7.15 SHOW ENGINE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-engine.html

An NdbTransaction is created each time a table schema operation (such as CREATE TABLE or ALTER TABLE) is performed on an NDB table. SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage engine. The ...

15.7.7.22 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/8.0/en/show-index.html

row *************************** Table: city Non_unique: 1 Key_name: CountryCode Seq_in_index: 1 Column_name: CountryCode Collation: A Cardinality: 232 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: Index_comment: Visible: YES ... SHOW ...

15.7.7.28 SHOW PROCEDURE STATUS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html

To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...

15.7.7.38 SHOW TABLE STATUS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html

See Chapter 17, The InnoDB Storage Engine, and Chapter 18, Alternative Storage Engines. When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable ...

15.7.7.39 SHOW TABLES Statement

https://dev.mysql.com/doc/refman/8.0/en/show-tables.html

The optional EXTENDED modifier causes SHOW TABLES to list hidden tables created by failed ALTER TABLE statements. SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a ...

7.4.5 The Slow Query Log

https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html

Administrative statements include ALTER TABLE, ANALYZE TABLE, CHECK TABLE, CREATE INDEX, DROP INDEX, OPTIMIZE TABLE, and REPAIR TABLE. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require ...

18.2.3.1 Static (Fixed-Length) Table Characteristics

https://dev.mysql.com/doc/refman/8.0/en/static-format.html

Static-format tables have these characteristics: CHAR and VARCHAR columns are space-padded to the specified column width, although the column type is not altered. It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, ...

Displaying 341 to 350 of 359 total results