python mysql conn_Python Mysql数据库连接

import MySQLdb

conn = MySQLdb.connect(host='127.0.0.1',user='root',passwd='redhat',db='test',port=3306)

cur = conn.cursor()

#cur.execute('select * from test')

cur.execute('insert into test value(3,13)')

#print cur.fetchone()

print  cur.fetchall()

cur.close()

conn.commit()

conn.close()

conn=MySQLdb.connect(host='127.0.0.1',user='root',passwd='redhat',port=3306)

cur=conn.cursor()

cur.execute('create database if not exists test1')

conn.select_db('test1')

cur.execute('create table test(id int,info varchar(20))')

value=[1,'hi one']

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

values=[]

for i in range(20):

values.append((i,'hi one'+str(i)))

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

cur.execute('update test set info="I am FreeMan" where id=3')

conn.commit()

cur.close()

conn.close()