Re: update all rows with a single script
I think you want different ids for each, otherwise you will end up with the last values only because you'd update the name and city each time.
But yes the code you have above is valid and won't throw an error.
can you show us what error is shown? can you specify where you are running the script? If you tried to run that in php for instance you would get an error because php limits you to one query at a time.
if you put it in a text file and ran it directly in mysql client you would have no problem.
Subject
Written By
Posted
Re: update all rows with a single script
January 27, 2009 11:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.