>>> import MySQLdb

>>> conn=MySQLdb.connect(user='root',passwd='111111',host='127.0.0.1',db='my_test')

>>> cur=conn.cursor()

>>> cur.execute("insert into users(name,age,sex) values('himi',11,'m'),('jimi',22,'f')")

2L

>>> sqli="insert into users(name,age,sex) values(%s,%s,%s)"    

>>> cur.executemany(sqli,[('limi',33,'f'),('zimi',44,'f')])    

2L

>>> cur.execute("delete from users where name='limi'")

1L

>>> cur.execute("update users set sex='man' where name='jimi'")

2L

>>> cur.execute("select * from users")

7L

>>> cur.fetchone()

('himi', 11L, 'm')

>>> cur.fetchone()

('jimi', 22L, 'man')

>>> cur.scroll(0,'absolute')

>>> cur.fetchone()

('himi', 11L, 'm')

>>> cur.fetchmany(2)

(('jimi', 22L, 'man'), ('jarry', 21L, 'girl'))

>>> cur.close()