Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-table-exists.html
This is an OUT parameter, so it must be a variable into which the table type can be stored. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
The following discussion further subdivides the set of system tables into smaller categories. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
Also take into account that the MyISAM storage engine needs two file descriptors for each unique open table. When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: ...
https://dev.mysql.com/doc/refman/8.4/en/truncate-table.html
The DATA DIRECTORY location will be ignored and the file will be put into the default datadir location. Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To ...
https://dev.mysql.com/doc/refman/8.4/en/union.html
query_expression_body UNION [ALL | DISTINCT] query_block [UNION [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” UNION combines the result from multiple ...
https://dev.mysql.com/doc/refman/8.4/en/using-stack-trace.html
On glibc-based systems (Linux), the trace for an unexpected exit within a plugin looks something like: plugin/auth/auth_test_plugin.so(+0x9a6)[0x7ff4d11c29a6] To translate the relative address (+0x9a6) into a file name and line number, use this ...
https://dev.mysql.com/doc/refman/8.4/en/windows-extract-archive.html
If this occurs, you can move the contents of the subfolder into the chosen installation location. To install MySQL manually, do the following: If you are upgrading from a previous version then refer to Section 3.11, “Upgrading MySQL on Windows” ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
There is usually a system built into the virus-scanning software to enable specific directories to be ignored. MySQL is available for Microsoft Windows 64-bit operating systems only. There are different methods to install MySQL on Microsoft ...
https://dev.mysql.com/doc/refman/8.4/en/windows-pluggable-authentication.html
Note Windows pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition for Windows supports an authentication method that performs external authentication on Windows, enabling ...
https://dev.mysql.com/doc/refman/8.4/en/windows-symbolic-links.html
On Windows, symbolic links can be used for database directories. This enables you to put a database directory at a different location (for example, on a different disk) by setting up a symbolic link to it. Use of database symlinks on Windows is ...