import MySQLdb
import time
import calendar
import pymysql
def timestamp(shijian):
s_t=time.strptime(shijian,"%Y-%m-%d %H:%M:%S")
mkt=int(time.mktime(s_t))
return(mkt)
db = MySQLdb.connect(
host="10.177.254.115", # 主机名
user="qq", # 用户名
passwd="123456", # 密码
db="qq") # 数据库名称
# 查询前,必须先获取游标
cur = db.cursor()
# 执行的都是原生SQL语句
cur.execute("SELECT * FROM qqq")
for row in cur.fetchall():
print(row[6])
print(timestamp(str(row[6])))
updata_time = timestamp(str(row[6]))
now_time = calendar.timegm(time.gmtime())
print(now_time-updata_time)
print('totally cost', round((now_time-updata_time)/60, 2), '分钟')
if round((now_time-updata_time)/60, 2)>= 120:
#如果更新时间过去2小时,就删除这条记录
print('这个过去了2小时,要删除\n------------------------------')
#cur.execute("DELETE FROM qqq WHERE UPDATED_AT_='"+ str(row[6]) +"';")
sql ="DELETE FROM qqq WHERE UPDATED_AT_='"+str(row[6])+"';"
cur.execute(sql)
db.commit()
else:
print('\n------------------------------')
db.close()
python 比较时间 删除mysql数据
最新推荐文章于 2023-02-20 17:59:58 发布