Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/creating-database.html
If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL ...
https://dev.mysql.com/doc/refman/9.7/en/derived-table-optimization.html
Thus, if an ER_UPDATE_TABLE_USED error occurs for a view reference that uses an expression equivalent to the subquery, adding ALGORITHM=TEMPTABLE to the view definition prevents merging and takes precedence over the derived_merge value. The ...
https://dev.mysql.com/doc/refman/9.7/en/drop-event.html
If the event does not exist, the error ERROR 1517 (HY000): Unknown event 'event_name' results. DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. The event immediately ceases being active, and is deleted completely ...