Search Results
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
[Warning] [MY-013453] [InnoDB] Clone removing all user data for provisioning: Finished If a failure occurs while removing data, the recipient may be left with a partial set of schemas, tables, and tablespaces that existed before the cloning ... This ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before converting. Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
Because MySQL works for many people, the crash might result from something that exists only on your computer (for example, an error that is related to your particular system libraries). Each MySQL version is tested on many platforms before it is ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
Such an index is created on the referencing table automatically if it does not exist. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent.
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
You can set READ_BACKUP for an existing table online, using an ALTER TABLE statement similar to one of those shown here: ALTER TABLE ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the ...
https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html
This means that two different sessions can use the same temporary table name without conflicting with each other or with an existing non-TEMPORARY table of the same name. (The existing table is hidden until the temporary table is dropped.) InnoDB ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking.html
MySQL Enterprise Edition provides data masking and de-identification capabilities: Transformation of existing data to mask it and remove identifying characteristics, such as changing all digits of a credit card number but the last four to 'X' ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp | +----------+ The mysql database describes user access privileges. If the test ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-functions.html
This section describes the functions that can be used to manipulate temporal values. See Section 13.2, “Date and Time Data Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...