Search Results
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-column.html
“What is the highest item number?” SELECT MAX(article) AS article FROM shop; +---------+ | article | +---------+ | 4 | +---------+ .
https://dev.mysql.com/doc/refman/8.4/en/example-storage-engine.html
The EXAMPLE storage engine is a stub engine that does nothing. Its purpose is to serve as an example in the MySQL source code that illustrates how to begin writing new storage engines. To enable the EXAMPLE storage engine if you build MySQL from ...
https://dev.mysql.com/doc/refman/8.4/en/except.html
As with UNION and INTERSECT, either query block can make use of any of SELECT, TABLE, or VALUES. query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See ...
https://dev.mysql.com/doc/refman/8.4/en/extended-show.html
Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of INFORMATION_SCHEMA itself. Several SHOW statements accept a WHERE clause that provides more ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-c-api.html
What is “MySQL Native C API”? What are typical benefits and use cases? A.13.2. What if I want to use the “NoSQL” X DevAPI? A.13.4. What is “MySQL Native C API”? What are typical benefits and use cases? libmysql is a C-based API that you ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
You can retrieve the current mode by issuing a SELECT @@sql_mode statement. What is the default server SQL mode when MySQL 8.4 is installed? A.3.1. What are server SQL modes? Server SQL modes define what SQL syntax MySQL should support and what kind ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-storage-engines.html
What are the unique benefits of the ARCHIVE storage engine? The ARCHIVE storage engine stores large amounts of data without indexes; it has a small footprint, and performs selects using table scans. Where can I obtain complete documentation for ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
You can obtain a listing of all triggers defined on database dbname using a query on the INFORMATION_SCHEMA.TRIGGERS table such as the one shown here: SELECT TRIGGER_NAME, EVENT_MANIPULATION, EVENT_OBJECT_TABLE, ACTION_STATEMENT FROM ...Where can I ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
This user must have been created on the remote server, and must have suitable privileges to perform the required actions (SELECT, INSERT, UPDATE, and so forth) on the remote table. To use the first method, you must specify the CONNECTION string ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
Enabling FIPS Mode in MySQL To determine whether MySQL is running on a system with FIPS mode enabled, check the value of the ssl_fips_mode server system variable using an SQL statement such as SHOW VARIABLES LIKE '%fips%' or SELECT @@ssl_fips_mode.