时间:2021-07-01 10:21:17 帮助过:3人阅读
#!/usr/bin/env python #encoding:utf-8 import MySQLdb print "<html>" print "<body>" print "<h1>book</h1>" print "<ul>" connection = MySQLdb.connect(user="root", passwd="123456", db="zabbix") cursor = connection.cursor() cursor.execute("SELECT * FROM users") for row in cursor.fetchall(): print "<li>%s</li>" % row[0] print "</ul>" print "</body></html>"
[root@bogon ~]# python mysql.py <html> <body> <h1>book</h1> <ul> <li>1</li> <li>2</li> </ul> </body></html> [root@bogon ~]#
yum install MySQL-python
本文出自 “砖家博客” 博客,请务必保留此出处http://wsxxsl.blog.51cto.com/9085838/1954439
python操作数据库
标签:py