Search Results
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
Truncating an InnoDB table that resides in a file-per-table tablespace drops the existing tablespace and creates a new one. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/tutorial.html
If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it contains. This chapter provides a tutorial introduction to MySQL by showing how to use the ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
Because the conversions produced by this library differ in some cases from non-dtoa results, the potential exists for incompatibilities in applications that rely on previous results. When an operator is used with operands of different types, type ...
https://dev.mysql.com/doc/refman/8.4/en/uln-installation.html
If you are changing your package source to use ULN and not changing which build of MySQL you are using, then back up your data, remove your existing binaries, and replace them with those from ULN. Linux supports a number of different solutions for ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-prerequisites.html
In this case, remove all redo log files and restart the MySQL 8.3 server on the existing data directory to address the errors. Before upgrading to the latest MySQL 8.4 release, ensure the upgrade readiness of your current MySQL 8.3 or MySQL 8.4 ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html
Although the new defaults are the best configuration choices for most use cases, there are special cases, as well as legacy reasons for using existing configuration choices. Before upgrading to MySQL 8.4, review the changes described in the ...
https://dev.mysql.com/doc/refman/8.4/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/8.4/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. Section 7.1.8, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
It can add new tokens or change the values of existing tokens. Before using Version Tokens, install it according to the instructions provided at Section 7.6.6.2, “Installing or Uninstalling Version Tokens”. A scenario in which Version Tokens ...
https://dev.mysql.com/doc/refman/8.4/en/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...