PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
Derived tables and common table expressions can also be specified in multiple-table UPDATE and DELETE statements, but can only be used for reading data to specify rows to be updated or deleted. For a view to be updatable, there must be a one-to-one ... Some views are updatable and references to them can be used to specify tables to be updated in data change ...
https://dev.mysql.com/doc/refman/8.0/en/window-functions.html
MySQL supports window functions that, for each row from a query, perform a calculation using rows related to that row. The following sections discuss how to use window functions, including descriptions of the OVER and WINDOW clauses. For ...
https://dev.mysql.com/doc/refman/8.0/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. Each row in these tables associates with the account in the user ... MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different ...
https://dev.mysql.com/doc/refman/8.0/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
The VIRTUAL or STORED keyword indicates how column values are stored, which has implications for column use: VIRTUAL: Column values are not stored, but are evaluated when rows are read, immediately after any BEFORE triggers. STORED: Column values ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
The server is free to ignore rows that become malformed as a result of such modifications. Another option for creating accounts is to use the GUI tool MySQL Workbench. To manage MySQL accounts, use the SQL statements intended for that purpose: ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-usage-differences.html
Consequently, depending on optimizer choices, the row order of results for INFORMATION_SCHEMA queries might differ from previous results. If a query result must have specific row ordering characteristics, include an ORDER BY clause. Use of a data ...
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. The number of columns retrieved by the SELECT statement must match the ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
Consider a query that joins the result of a derived table to another table: If the optimizer processes that other table first and finds that it returns no rows, the join need not be carried out further and the optimizer can completely skip ...The ...
https://dev.mysql.com/doc/refman/8.0/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...