PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/union.html
UNION queries with an aggregate function in an ORDER BY clause are rejected with an ER_AGGREGATE_ORDER_FOR_UNION error. [UNION [ALL | DISTINCT] SELECT ...] UNION combines the result from multiple SELECT statements into a single result set. Selected ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
UPDATE is a DML statement that modifies rows in a table. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET assignment_list [WHERE where_condition] [ORDER BY ...] [LIMIT row_count] value: {expr | DEFAULT} assignment: col_name = ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
When selecting primary key columns, choose columns with the following characteristics: Columns that are referenced by the most important queries. InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b ...
https://dev.mysql.com/doc/refman/5.7/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 8.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website (http://www.mysql.com/) provides the latest information about MySQL software. It may be anything ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
As well as enabling you to configure connection parameters, MySQL Workbench provides the capability to execute SQL queries on the database connections using the built-in SQL Editor. MySQL Workbench provides a graphical tool for working with MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/adding-character-set.html
This section discusses the procedure for adding a character set to MySQL. The proper procedure depends on whether the character set is simple or complex: If the character set does not need special string collating routines for sorting and does not ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation.html
A collation is a set of rules that defines how to compare and sort character strings. Every character set has at least one collation, and most have two or more collations. Characters with equal weights compare as equal, and characters with unequal ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
Standard SQL uses the C syntax /* this is a comment */ for comments, and MySQL Server supports this syntax as well. MySQL also support extensions to this syntax that enable MySQL-specific SQL to be embedded in the comment; see Section 9.6, ...