Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'connection%'; +------------------------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | ... This section describes how ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a nontransactional storage engine, MySQL stops processing the statement at the row ...If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...
https://dev.mysql.com/doc/refman/8.4/en/corrupted-myisam-tables.html
Typical symptoms of a corrupt table are: You get the following error while selecting data from the table: Incorrect key file for table: '...'. You can verify this easily by looking for a recent restarted mysqld message in the error log. Even though ...
https://dev.mysql.com/doc/refman/8.4/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
IF NOT EXISTS prevents an error from occurring if there already exists a loadable function with the same name. It does not prevent an error from occurring if there already exists a built-in function having the same name. CREATE [AGGREGATE] FUNCTION ...
https://dev.mysql.com/doc/refman/8.4/en/create-resource-group.html
If a CPU number is an integer outside the permitted range or is not an integer, an error occurs. CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
If expression evaluation causes truncation or provides incorrect input to a function, the CREATE TABLE statement terminates with an error and the DDL operation is rejected. If the column is also declared as NOT NULL, attempting to insert NULL is ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
Setting a value greater than 29980 raises an error; setting a value less than 1 is allowed, but causes the default inline size for the column type to be used. Using any value other than 0 or 1 results in a syntax error. NDB_COLUMN Options NDB_TABLE ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part of the view, and columns dropped from the table result in an error when selecting from the view. If, after the view has been created, a ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...