in reply to DBI SQL Syntax Problem
I was in the process of writing an RTFM reply citing the MySQL doc for UPDATE, but found that it begins with
which is wrong about comma placement (in a subtle way). It should readUPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1, [col_name2=expr2, ...] [WHERE where_definition] [LIMIT #]
I've sent a note about this to the MySQL folks.UPDATE [LOW_PRIORITY] [IGNORE] tbl_name SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition] [LIMIT #]
Update: They've made the correction. Quick turnaround on their part.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: DBI SQL Syntax Problem
by jerrygarciuh (Curate) on Apr 15, 2002 at 18:05 UTC |