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]))
上面演示了插入和查询,更新 删除都差不多类似,举一反三即可;附截图。