Python: Text file insert to MySQL
gh at ghaering.de
Wed Oct 7 13:39:29 CEST 2009
On Wed, Oct 7, 2009 at 1:32 PM, Schedule <sschedule at gmail.com> wrote:
> That was great ! Now I am able to insert the values from the file.
> Somehow I am not able to update a specific field with all the vaues in the
> file. For eg:
> c.execute("UPDATE a SET last = %s", row)
The database does what you say, not what you mean ;-)
SQL commands like SELECT, UPDATE, DELETE work on sets. If you don't
qualify the set any further, you always operate on the whole set.
To restrict the set, apply a WHERE clause. I. e.
Perhaps you should try a SQL tutorial before jumping into SQL +
Python. Here's one:
More information about the Python-list