python数据库操作

#-*- coding:utf-8 -*-

#中文注释

#安装python SQL后引入,下载地址：https://pypi.python.org/packages/27/06/596ae3afeefc0cda5840036c42920222cb8136c101ec0f453f2e36df12a0/MySQL-python-1.2.5.win32-py2.7.exe#md5=6f43f42516ea26e79cfb100af69a925e

import MySQLdb

#创建链接

conn = MySQLdb.connect(host = '' , user = '' , passwd = '')

#选择数据库

conn.select_db('');

#创建表

cursor.execute("""CREATE TABLE test (id int,info varchar(100))""")

#插入数据

cursor.execute("INSERT INTO test(id,info)VALUES('' , '')")

#提交到表中

conn.commit()

#查询记录

aa = cursor.execute("select * from test")

#打印记录条数

print aa

#获取记录

bb = cursor.fetchall()

#循环并打印

for row in bb:

　　print row

#关闭指针

cursor.close()