Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
INSERT INTO t1 (latin1_column) SELECT USER(); This works because the contents of USER() are automatically converted to latin1 before the assignment. Metadata is “the data about the data.” Anything that describes the database—as opposed to ...
https://dev.mysql.com/doc/refman/8.4/en/constraints.html
We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error occurs. MySQL enables you to work both with transactional tables that permit rollback and with ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query execution. The optimizer has a set of compiled-in default “cost constants” available to it to make ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
CREATE FUNCTION requires the INSERT privilege for the mysql system schema because it adds a row to the mysql.func system table to register the function. CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} ...
https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html
The creating session can perform any operation on the table, such as DROP TABLE, INSERT, UPDATE, or SELECT. You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only within the current session, and is dropped ...
https://dev.mysql.com/doc/refman/8.4/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
Indexes are good for retrieval, but slow down insert and update operations. Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount of data written to and read from disk. Smaller tables ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
This makes TIMESTAMP useful for recording the timestamp of an INSERT or UPDATE operation. The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the DATE and DATETIME range descriptions, ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-concepts.html
In terms of MySQL this means: Create a new document (insertion or addition) Read one or more documents (queries) Update one or more documents Delete one or more documents . This section explains the concepts introduced as part of using MySQL as a ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-installation.html
To install the component, issue this INSTALL COMPONENT statement: INSTALL COMPONENT "file://component_enterprise_encryption"; INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to ... The functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the ...