Search Results
https://dev.mysql.com/doc/refman/8.4/en/comparisons-using-subqueries.html
It finds all rows in table t1 containing a value that occurs twice in a given column: SELECT * FROM t1 AS t WHERE 2 = (SELECT COUNT(*) FROM t1 WHERE t1.id = t.id); For a comparison of the subquery to a scalar, the subquery must return a scalar. The ...
https://dev.mysql.com/doc/refman/8.4/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are compressed. Command Options for Connection ...These options can be given on the command line or in an option ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/refman/8.4/en/create-database.html
CREATE DATABASE is not permitted within a session that has an active LOCK TABLES statement. The ENCRYPTION option defines the default database encryption, which is inherited by tables created in the database. If the ENCRYPTION option is not ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-type-syntax.html
For example: CREATE TABLE t1 (t TIME(3), dt DATETIME(6), ts TIMESTAMP(0)); The fsp value, if given, must be in the range 0 to 6. (This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Any TIMESTAMP or ...
https://dev.mysql.com/doc/refman/8.4/en/drop-function-loadable.html
It requires the DELETE privilege for the mysql system schema because it removes the row from the mysql.func system table that registers the function. DROP FUNCTION also removes the function from the Performance Schema user_defined_functions table ...
https://dev.mysql.com/doc/refman/8.4/en/dynamic-system-variables.html
For a description of the privilege requirements for setting system variables, see Section 7.1.9.1, “System Variable Privileges” The following table lists all dynamic system variables applicable within mysqld. This differs from the ENUM data type ... Many server system variables are dynamic and can be set at ...
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
At this point, it is more important to find out a little about how to issue queries than to jump right in creating tables, loading data into them, and retrieving data from them. Normally, column labels are the names of the columns you fetch from ...
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/examples.html
Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Here are examples of how to solve some common problems with MySQL. Supposing that each trader has a single fixed price per ...