python3.6 mysql链接及操作

xiaoxiao2021-02-28  5

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]))

上面演示了插入和查询,更新 删除都差不多类似,举一反三即可;附截图。

转载请注明原文地址: https://www.6miu.com/read-1600139.html

最新回复(0)