python 使用mysql
- 使用的python版本3.x
- 导入包
import pymysql.cursors
-
# 连接数据库 connect = pymysql.Connect( host='192.168.1.80', port=3306, user='root', passwd='121212', db='test', charset='utf8' )
- 普通操作
# 获取游标 cursor = connect.cursor() # 插入数据 sql = "INSERT INTO nickname (nickname, create_at) VALUES ( '%s', '%s')" data = (nickname, time.strftime('%Y-%m-%d %H:%M:%S',time.localtime(time.time()))) cursor.execute(sql % data) connect.commit() print('成功插入', cursor.rowcount, '条数据') cursor.close() connect.close()