question about deleting records from mysql

nephish at xit.net nephish at xit.net
Wed Jul 27 07:29:33 EDT 2005


Hey there,
sorry , second question in as many days.
i am trying to do some stuff with MySQLdb and the thing is, i can
select records and such, but when i try to delete them, they dont
really go away.

like this

>>> cursor.execute("DELETE FROM table WHERE autoinc > 1000")
240L
>>> cursor.execute("SELECT * FROM table WHERE autoinc > 1000")
0L

so it looks like it worked, but when i use something else to look at
the
table (phpmyadmin, mysql-query-browser, knoda) the records are still
there!

what do i do?




More information about the Python-list mailing list