MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 11 to 18 of 18 total results

« Previous
1
2
Next »

30.4.5.16 The ps_thread_stack() Function

https://dev.mysql.com/doc/refman/9.7/en/sys-ps-thread-stack.html

Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ID. The value should match the THREAD_ID column from some Performance Schema threads table row. row *************************** ...

30.4.4.3 The execute_prepared_stmt() Procedure

https://dev.mysql.com/doc/refman/9.7/en/sys-execute-prepared-stmt.html

Parameters in_query LONGTEXT CHARACTER SET utf8mb3: The statement string to execute. Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to reuse.

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/9.7/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...

13.5 The JSON Data Type

https://dev.mysql.com/doc/refman/9.7/en/json.html

The space required to store a JSON document is roughly the same as for LONGBLOB or LONGTEXT; see Section 13.7, “Data Type Storage Requirements”, for more information. The JSON data type provides these advantages over storing JSON-format strings ...

17.21 InnoDB Limits

https://dev.mysql.com/doc/refman/9.7/en/innodb-limits.html

LONGBLOB and LONGTEXT columns must be less than 4GB, and the total row size, including BLOB and TEXT columns, must be less than 4GB. This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage ...

17.11.2 File Space Management

https://dev.mysql.com/doc/refman/9.7/en/innodb-file-space.html

LONGBLOB and LONGTEXT columns must be less than 4GB, and the total row length, including BLOB and TEXT columns, must be less than 4GB. The data files that you define in the configuration file using the innodb_data_file_path configuration option ...

MySQL Glossary

https://dev.mysql.com/doc/refman/9.7/en/glossary.html

CLOB An SQL data type (TINYTEXT, TEXT, MEDIUMTEXT, or LONGTEXT) for objects containing any kind of character data, of arbitrary size. These terms are commonly used in information about the MySQL database server. Files with this extension are always ...

14.10 Cast Functions and Operators

https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html

If the length is still too long, the result type is LONGTEXT. Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain ...