Search Results
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
BLOB and TEXT columns only contribute 9 to 12 bytes toward the row size limit because their contents are stored separately from the rest of the row. You have to change some columns to TEXT or BLOBs mysql> CREATE TABLE t (a VARCHAR(10000), b ... This ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification for a string column, you can create an index that uses only the first N characters of the column.
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
activate_all_roles_on_login applies only at login time, and at the beginning of execution for stored programs and views that execute in definer context. A client that authenticates using the InitSecurityContext() function should provide a string ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
You have to change some columns to TEXT or BLOBs Error number: 1119; Symbol: ER_STACK_OVERRUN; SQLSTATE: HY000 Message: Thread stack overrun: Used: %ld of a %ld stack. Error number: 1756; Symbol: ER_MTA_INCONSISTENT_DATA; SQLSTATE: HY000 Message: %s ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using the GenAI feature of MySQL AI: Before You Begin Generating Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-generate-table.html
The ML_GENERATE_TABLE routine runs multiple text generation or summarization queries in a batch, in parallel. The input column must already exist and must contain text or varchar values. OutputTableColumn: specifies the names of the database, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
If table and column names are non-descriptive, the ability to scan table and column comments in the table to retrieve additional contextual information for preparing queries. mysql> SELECT @output; ... Available as of MySQL 9.4.0, the NL2ML routine ...
https://dev.mysql.com/doc/refman/8.4/en/show-parse-tree.html
SHOW PARSE_TREE select_statement SHOW PARSE_TREE displays a representation of the parse tree for the input SELECT statement, in JSON format. Note This statement is available only in debug builds, or if the MySQL server was built using ...
https://dev.mysql.com/doc/refman/8.4/en/storage-requirements.html
This figure excludes BLOB or TEXT columns, which contribute only 9 to 12 bytes toward this size. For BLOB and TEXT data, the information is stored internally in a different area of memory than the row buffer. For example, storage for a MEDIUMTEXT ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/server-plugin-descriptors.html
This is the value that identifies the plugin as being legal for use in a WITH PARSER clause when creating a FULLTEXT index. Every plugin library that contains server plugins must include a library descriptor that contains the general plugin ...