question about deleting records from mysql

Rowdy david at fielden.com.au
Wed Jul 27 08:43:24 EDT 2005


nephish at xit.net wrote:
> ok. did this
> 
> 
>>>>cursor.execute("DELETE FROM table WHERE autoinc > 1000")
> 
> 245L
> 
>>>>cursor.commit()
> 
> 
> i got an AttributeError 'Cursor' object has no attribute 'commit'
> 
> hmm. what should i do now?
> the stuff about writing a lightweight layer between the dbapi and the
> program shot right over my head. sorry, but thanks
> 

IIRC it is the connection that can commit(), not the cursor.

Rowdy



More information about the Python-list mailing list