Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-tables.html
Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); VARCHAR is a good choice for the name, owner, and species ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
However, MySQL supports access to data stored in data dictionary tables through INFORMATION_SCHEMA tables and SHOW statements. MySQL system tables still exist in MySQL 8.4 and can be viewed by issuing a SHOW TABLES statement on the mysql system ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter-installation.html
The primary use case is modification of statements restored from dump files, so the typical usage pattern is: 1) Install the plugin; 2) restore the dump file or files; 3) uninstall the plugin. To install the ddl_rewriter plugin, use the INSTALL ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
For example, to load the JSON log sink, issue the following statement: INSTALL COMPONENT 'file://component_log_sink_json'; Loading a component using INSTALL COMPONENT registers it in the mysql.component system table so that the server loads it ...
https://dev.mysql.com/doc/refman/8.4/en/example-user-variables.html
You can employ MySQL user variables to remember results without having to store them in temporary variables in the client.
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
For the syntax required to perform multiple-table updates, see Section 15.2.17, “UPDATE Statement”; for that required to perform multiple-table deletes, see Section 15.2.2, “DELETE Statement”. A multiple-table insert can be accomplished ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-views.html
To check a view definition for problems of this kind, use the CHECK TABLE statement. Can you insert into views that are based on joins? It is possible, provided that your INSERT statement has a column list that makes it clear there is only one table ...What happens to a view if an underlying table is dropped or renamed? ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-elements.html
MySQL Enterprise Firewall is based on a plugin library that includes these elements: A server-side plugin named MYSQL_FIREWALL examines SQL statements before they execute and, based on the registered firewall profiles, renders a decision whether to ...The MYSQL_FIREWALL plugin, along with server-side plugins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL_WHITELIST implement Performance Schema and INFORMATION_SCHEMA tables that provide views into the registered ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-installation.html
To verify that, connect to the server and execute this statement: mysql> SHOW GLOBAL VARIABLES LIKE 'mysql_firewall_mode'; +---------------------+-------+ | Variable_name | Value | +---------------------+-------+ | mysql_firewall_mode | ON | ...