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
query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” EXCEPT limits the result ...
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
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 of data validation checks it should perform. This makes it easier to use ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-storage-engines.html
Where can I obtain complete documentation for MySQL storage engines? A.2.2. Can I prevent the use of a particular storage engine? A.2.5. Is there an advantage to using the InnoDB storage engine exclusively, as opposed to a combination of InnoDB and ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-triggers.html
Where can I find the documentation for MySQL 8.4 triggers? A.5.2. Is there a way to view all triggers in a given database? A.5.7. Can a table have multiple triggers with the same trigger event and action time? A.5.11. Is it possible for a trigger to ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) ...
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host system. FIPS mode on the server side applies to cryptographic operations performed by the server. This includes replication (source/replica ...