mysqldoc: lack of ORDER BY in UPDATE synopsis

Hi, Paul,

seems to me there is "ORDER BY" missing in synopsis:

----------------------
`UPDATE' Syntax
---------------

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]

`UPDATE' updates columns in existing table rows with new values. The
`SET' clause indicates which columns to modify and the values they
should be given. The `WHERE' clause, if given, specifies which rows
should be updated. Otherwise, all rows are updated. If the `ORDER BY'
clause is specified, the rows will be updated in the order that is
specified.
----------------------

How-To-Repeat:


--w


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12985@lists.mysql.com
To unsubscribe, e-mail

Re: mysqldoc: lack of ORDER BY in UPDATE synopsis

Vladimir V. Kolpakov writes:
> Hi, Paul,
>
> seems to me there is "ORDER BY" missing in synopsis:
>
> ----------------------
> `UPDATE' Syntax
> ---------------
>
> UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
> SET col_name1=expr1 [, col_name2=expr2, ...]
> [WHERE where_definition]
> [LIMIT #]
>
> `UPDATE' updates columns in existing table rows with new values. The
> `SET' clause indicates which columns to modify and the values they
> should be given. The `WHERE' clause, if given, specifies which rows
> should be updated. Otherwise, all rows are updated. If the `ORDER BY'
> clause is specified, the rows will be updated in the order that is
> specified.
> ----------------------
>
> How-To-Repeat:
>

Hi!

I have checked your report.

ORDER BY was added in 4.0 and only 3.23 manual does not have it
mentioned as that version does not support it.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12988@lists.mysql.com
To unsubscribe, e-mail