Python 的 MySQLdb 模块

import MySQLdb

try:

    conn = MySQLdb.connect(host=‘‘,user=‘‘,passwd=‘‘,db=‘‘,port=)

    cur = conn.cursor()

    conn.select_db(‘db_name‘)

    value = [1,‘colben‘]

    cur.execute(‘insert into test values(%s,%s)‘,value)

    values = [(1,‘colben‘),(2,‘shelly‘)]

    cur.executemany(‘insert into test values(%s,%s)‘,values)

    cur.fetchall()

    cur.fetchmany(size)

    cur.fetchone()

    conn.commit()

    conn.rollback()

    cur.close()

    conn.close()

except MySQLdb.Error,e:

    print ‘Mysql Error %d: %s‘%(e.args[0], e.args[1])

Python 的 MySQLdb 模块

标签：