python链接mysql需要安装pymysql这个扩展，直接pip安装就可以，或者使用pycharm直接搜索pymysql；安装就行了。
#!/usr/bin/python # -*- coding: UTF-8 -*- import pymysql.cursors import time connect = pymysql.Connect( host='localhost', port=3306, user='root', passwd='', db='sphinx_test', charset='utf8' ) #设置自动提交 connect.autocommit(1) cursor = connect.cursor() sql = "INSERT INTO sphinx_user (username,password,status,create_time,last_login_time) VALUES ('%s','%s','%d','%s','%s')" create_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) last_login_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) data = ('gxx','123456',1,create_time,last_login_time) #cursor.execute(sql % data) #print('成功插入', cursor.rowcount, '条数据') #查询数据表 sql = "SELECT * FROM sphinx_user" cursor.execute(sql) for row in cursor.fetchall(): print('username:%s--password:%s--create_time:%s' % (row[0],row[1],row[4]))上面演示了插入和查询，更新 删除都差不多类似，举一反三即可；附截图。
