MySQL Forums
Forum List  »  Connector/Python

Advanced Search
New Topic

Re: Running Updates row by row, beginners Q
Posted by: Tobin Cataldo
Date: September 26, 2007 09:16AM

cursor.execute(("""UPDATE tableSET latitude =%s, longitude = %s"""), (lat, lng))

You need a WHERE clause to uniquely identify each row.
http://dev.mysql.com/doc/refman/5.0/en/update.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Running Updates row by row, beginners Q
Henry LaForge
September 19, 2007 02:10PM
Re: Running Updates row by row, beginners Q
Tobin Cataldo
September 26, 2007 09:16AM


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.