update and delete

Help
2010-07-29
2012-09-19
  • norman khine

    norman khine - 2010-07-29

    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

    Jack Repenning - 2010-07-30

    I think you're looking for

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

     

Log in to post a comment.