update and delete

[norman khine]

hello,

i have this code:

http://pastie.org/1066163

if i want to also delete the rows from results of:

main.execute('SELECT product_Id, url FROM %s.product WHERE url IS NOT NULL' %
db)

once i make the update, would i have to make an additional loop or can this be
done differently?

thanks

[Jack Repenning]

I think you're looking for

main.execute('DELETE FROM %s.product WHERE url IS NOT NULL' % db)