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/select-optimization.html
Keep table statistics up to date by using the ANALYZE TABLE statement periodically, so the optimizer has the information needed to construct an efficient execution plan. Queries, in the form of SELECT statements, perform all the lookup operations ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-all.html
For example, you may happen to think that the birth date for Bowser does not seem quite right. Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html
As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, particularly when it becomes large. Instead, you're usually more interested in answering a particular question, in ...
https://dev.mysql.com/doc/refman/5.7/en/server-loadable-functions.html
See Section 5.5.4, “The Rewriter Query Rewrite Plugin” Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports loadable functions, ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
--sql-mode=value[,value[,value...]] Command-Line Format --sql-mode=name System Variable sql_mode Scope Global, Session Dynamic Yes Type Set Default Value ONLY_FULL_GROUP_BY STRICT_TRANS_TABLES NO_ZERO_IN_DATE NO_ZERO_DATE ERROR_FOR_DIVISION_BY_ZERO ... When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
Version Tokens enables creation of and synchronization around server tokens that applications can use to prevent accessing incorrect or out-of-date data. MySQL supports an plugin API that enables creation of server plugins. Plugins can be loaded at ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE ... SHOW CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. A ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...