python 读取 mysql 日期型字段

最新推荐文章于 2024-08-07 14:53:54 发布

james_laughing

最新推荐文章于 2024-08-07 14:53:54 发布

阅读量6.7k

点赞数

分类专栏： flask python 文章标签： flask python mysql datetime

本文链接：https://blog.csdn.net/james_laughing/article/details/89349432

版权

flask 同时被 2 个专栏收录

48 篇文章 0 订阅

订阅专栏

python

36 篇文章 0 订阅

订阅专栏

course["time"] = record[7].strftime('%Y-%m-%d %H:%M:%S')

import time, datetime

import pymysql
import json

conn = pymysql.connect("localhost", "username", "password", "db")

cursor = conn.cursor()

cursor.execute("select * from table")

print(cursor.rowcount)
courses = []
for i in range(cursor.rowcount):
    record = cursor.fetchone()
    course = {}

    course["col1"] = record[1]
    course["col12"] = record[2].strftime('%Y-%m-%d %H:%M:%S')

    courses.append(course)
print("mysql=", courses)

conn.close()