MySQL Forums
Forum List  »  PHP

Re: update all rows with a single script
Posted by: Guelphdad Lake
Date: January 27, 2009 11:06AM

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.

Options: ReplyQuote


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.