Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...
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/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/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 ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
This user must have been created on the remote server, and must have suitable privileges to perform the required actions (SELECT, INSERT, UPDATE, and so forth) on the remote table. To use the first method, you must specify the CONNECTION string ...
https://dev.mysql.com/doc/refman/8.4/en/federated-description.html
When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
Insert the name of the custom schema to be used as the firewall database. MySQL Enterprise Firewall installation is a one-time operation that installs the elements described in Section 8.4.7.1, “Elements of MySQL Enterprise Firewall”.