PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
To use the console: Open a command prompt with administrative privileges by selecting Windows System from Start, then right-click Command Prompt, select More, and select Run as administrator. action_blocks_list A list of blocks in which each ...
https://dev.mysql.com/doc/refman/5.7/en/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-tables.html
SQL statements are expressed as text, such as DELETE FROM t1 or SELECT * FROM t2. Instruments for SQL statements have names that begin with statement/sql, such as statement/sql/delete and statement/sql/select. For example, SELECT * FROM is ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-alias.html
An alias can be used in a query select list to give a column a different name. In the select list of a query, a quoted column alias can be specified using identifier or string quoting characters: SELECT 1 AS `one`, 2 AS 'two'; Elsewhere in the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. For example, you cannot convert the ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
Thus, the following query fails with a syntax error: SELECT * FROM t1 WHERE ROW(1) = (SELECT column1 FROM t2) Row constructors are legal in other contexts. Scalar or column subqueries return a single value or a column of values. A row subquery is a ...
https://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html
Nullability of the value selected by a scalar subquery is not copied because if the subquery result is empty, the result is NULL. When you see examples in the following sections that contain the rather spartan construct (SELECT column1 FROM t1), ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
table_references and where_condition are specified as described in Section 13.2.9, “SELECT Statement”. You need only the SELECT privilege for any columns that are read but not modified. Here is an example: UPDATE items,month SET ... UPDATE is a ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
There is a general principle that you cannot modify a table and select from the same table in a subquery. The same principle also applies if you select from a view that selects from the table, if the view selects from the table in a subquery and the ... The maximum number of tables that can be referenced in the definition of a view is ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
For dependent subqueries in the select list, no data change statements are permitted. SET c=c+1; This statement is invalid; it tries to update a materialized derived table: UPDATE vup JOIN (SELECT SUM(x) AS s FROM t1) AS dt ON ... Consider this ...