Hi everyone...
I'm trying to update a few columns on one row using an sql statement, but I don't seem to have the correct syntax...
I'm using :-
$dbh->do("update <tablename> set <column1> = <new-value1> <column2> = <new-value2> where <column3> = <value3>");
This doesn't work... however if update only one column it does, so I figure I must be missing something. I've looked through the docs and can only find update examples with one column to be updated.
Please help!!!!!!
Simon
OK...... I RTFM'd on the mySQL site and there was the answer... a comma !!!
Simon
On Tuesday 11 June 2002 12:22 pm, Simon wrote:
Hi everyone...
I'm trying to update a few columns on one row using an sql statement, but I don't seem to have the correct syntax...
I'm using :-
$dbh->do("update <tablename> set <column1> = <new-value1> <column2> = <new-value2> where <column3> = <value3>");
This doesn't work... however if update only one column it does, so I figure I must be missing something. I've looked through the docs and can only find update examples with one column to be updated.
Please help!!!!!!
Simon
main@lists.alug.org.uk http://www.anglian.lug.org.uk/ http://lists.alug.org.uk/mailman/listinfo/main Unsubscribe? See message headers or the web site above!
On Tue, 11 Jun 2002, Simon wrote:
$dbh->do("update <tablename> set <column1> = <new-value1> <column2> = <new-value2> where <column3> = <value3>");
$dbh->do("update <tablename> set <column1> = <new-value1>, <column2> = <new-value2> where <column3> = <value3>");
(missing ,)
Andrew.
-
Andrew Savory -
Simon