Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin directory. This program reads the files created as a result of the backup and inserts the stored ...This ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
This being the case, we discuss in this section how each MySQL partitioning type handles NULL values when determining the partition in which a row should be stored, and provide examples for each. Partitioning in MySQL does nothing to disallow NULL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-tables.html
These tables store statement events: events_statements_current: The current statement event for each thread. For a request read as a statement from the relay log on a replica: Statements in the relay log are stored as text and are read as such. An ...Statement events occur at a high level of the event ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-system-variables.html
When a new table row is inserted, the statement that produced the row digest value is stored as the current sample statement associated with the digest. performance_schema_max_sql_text_length Command-Line Format ...The Performance Schema ...
https://dev.mysql.com/doc/refman/8.4/en/rename-user.html
RENAME USER fails with an error if any account to be renamed is named as the DEFINER attribute for any stored object. (That is, the statement fails if renaming an account would cause a stored object to become orphaned.) To perform the operation ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-functions.html
For example, you cannot convert the following statement to one in which a given individual user variable is associated with each row: INSERT INTO t2 SELECT UUID(), * FROM t1; Within a stored function, RAND() replicates correctly as long as it is ...
https://dev.mysql.com/doc/refman/8.4/en/roles.html
Stored program and view objects that execute in definer context execute with the default roles of the user named in their DEFINER attribute. For stored programs, if execution should occur with roles different from the default, the program body can ...Like user accounts, roles can have privileges granted to and revoked from ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engines.html
InnoDB stores user data in clustered indexes to reduce I/O for common queries based on primary keys. Memory: Stores all data in RAM, for fast access in environments that require quick lookups of non-critical data. Blackhole: The Blackhole storage ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
For example, '41' is stored into a CHAR(3) column as '41 ' and retrieved as '41' (with the trailing pad space stripped), so UNHEX() for the column value returns X'41'. By contrast, '41' is stored into a BINARY(3) column as '41\0' and retrieved as ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-type-conversions.html
Here are some examples: If you use MYSQL_TYPE_LONG with an int variable to pass an integer value to the server that is to be stored into a FLOAT column, MySQL converts the value to floating-point format before storing it. If you specify ... Prepared ...