Python-сообщество

import MySQLdb
conn = MySQLdb.connect (host = "localhost",
                           user = "root",
                           passwd = "password",
                           db = "devdb")   
cursor = conn.cursor ()
## skipped
for key in y:
    ## skipped 
    text = str(sortedlist)[1:-1]
    print "TEXT for id = %d" %key, text
    #cursor.execute('INSERT INTO similar_tags (tag_id,ids_text) VALUES (%d,"%s"); '\
    #    %(key,text))
    s ="INSERT INTO similar_tags (tag_id,ids_text)\
    VALUES (%d,'%s'); "\
        %(key,text)
    print "s= ",s
    #cursor.execute(s)
    cursor.execute("""
    INSERT INTO similar_tags (tag_id,ids_text)\
    VALUES (%s,%s);
    """,(key,text) )
    print "Number of rows inserted: %d" % cursor.rowcount

TEXT for id = 7 8L, 6L, 5L, 4L, 3L, 2L, 1L
s=  INSERT INTO similar_tags (tag_id,ids_text)    VALUES (7,'8L, 6L, 5L, 4L, 3L, 2L, 1L'); 
Number of rows inserted: 1
TEXT for id = 8 7L, 6L, 5L, 4L, 3L, 2L, 1L
s=  INSERT INTO similar_tags (tag_id,ids_text)    VALUES (8,'7L, 6L, 5L, 4L, 3L, 2L, 1L'); 
Number of rows inserted: 1