|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
#!/usr/bin/env python # coding=utf-8 # first install : yum install MySQL-python import MySQLdb try: conn = MySQLdb.connect(host='localhost',user='root',passwd='yourpasswd',port=3306) cur=conn.cursor() conn.select_db('mysql') count = cur.execute('select count(*) from user') print count cur.close() conn.close() except MySQLdb.Error,e: print "Mysql Error %d: %s" % (e.args[0], e.args[1]) |
Latest posts by Zhiming Zhang (see all)
- Helm 文档能好好测测再写么 - 十二月 12, 2019
- 通过crontab来执行ansible-playbook 自动加载ssh-key的问题 - 十二月 9, 2019
- ansible set_fact loop 仅保留最后一个值的问题 - 十二月 3, 2019