diff options
Diffstat (limited to 'Docs/manual.texi')
| -rw-r--r-- | Docs/manual.texi | 29 |
1 files changed, 27 insertions, 2 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index a5567f00566..f51b779414f 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -3628,7 +3628,7 @@ Use of @code{REPLACE} instead of @code{DELETE} + @code{INSERT}. @xref{REPLACE, , @code{REPLACE}}. @item -The @code{FLUSH flush_option} statement. +The @code{FLUSH}, @code{RESET} and @code{DO} statements. @item The possibility to set variables in a statement with @code{:=}: @@ -31993,6 +31993,9 @@ and @code{NULL} if the named lock didn't exist. The lock will not exist if it was never obtained by a call to @code{GET_LOCK()} or if it already has been released. +The @code{DO} statement is convinient to use with @code{RELEASE_LOCK()}. +@xref{DO}. + @findex BENCHMARK() @item BENCHMARK(count,expr) The @code{BENCHMARK()} function executes the expression @code{expr} @@ -32064,6 +32067,7 @@ facilitate replication testing. * TRUNCATE:: @code{TRUNCATE} Syntax * REPLACE:: @code{REPLACE} Syntax * LOAD DATA:: @code{LOAD DATA INFILE} Syntax +* DO:: @code{DO} Syntax @end menu @node SELECT, INSERT, Data Manipulation, Data Manipulation @@ -32973,7 +32977,7 @@ The above makes it easy to check if @code{REPLACE} added or replaced a row. -@node LOAD DATA, , REPLACE, Data Manipulation +@node LOAD DATA, DO, REPLACE, Data Manipulation @subsection @code{LOAD DATA INFILE} Syntax @findex LOAD DATA INFILE @@ -33469,6 +33473,23 @@ For more information about the efficiency of @code{INSERT} versus @xref{Insert speed}. +@node DO, , LOAD DATA, Data Manipulation +@subsection @code{DO} Syntax + +@findex DO + +@example +DO expression, [expression, ...] +@end example + +Execute the expression but don't return any results. This is a +shorthand of @code{SELECT expression, expression}, but has the advantage +that it's slightly faster when you don't care about the result. + +This is mainly useful with functions that has side effects, like +@code{RELEASE_LOCK}. + + @node Data Definition, Basic User Commands, Data Manipulation, Reference @section Data Definition: @code{CREATE}, @code{DROP}, @code{ALTER} @@ -46867,6 +46888,10 @@ not yet 100% confident in this code. @appendixsubsec Changes in release 3.23.47 @itemize @bullet @item +Fixed core-dump bug in replication when using SELECT RELEASE_LOCK(); +@item +Added new statement DO expression,[expression]. +@item Added @code{slave-skip-errors} option @item Added statistics variables for all MySQL commands. (@code{SHOW STATUS} is |