python sqlalchemy数据库操作
先安装sqlalchemy下载 SQLAlchemy-0.4.1然后 打开cmd 在此文件夹下,python setup.py install
注意如果用的是mysql数据,还要安装MYSQLDB,这个下载以后双击安装
from sqlalchemy import *
mysql_engine = create_engine("mysql://root:root@127.0.0.1/test")
connection = mysql_engine.connect()
result = connection.execute("select name from tname")
for row in result:
print "name:", row['name']
connection.close()
这样就成功了
页:
[1]