数据库
一夜白头催人泪
一夜白头催人泪
展开
-
docker-compose安装MariaDB
天才有两种,一种是天生的,一种是努力的原创 2023-03-01 14:09:02 · 1397 阅读 · 0 评论 -
python操作mongo数据库返回字典
1.MANGO_DATABASES["HOST"] 是主机IP2.MANGO_DATABASES["DB"] 是数据库名字3.MANGO_DATABASES["db3"]是表名class MangoOperationMoney: """操作mango数据库返回字典 """ def __init__(self): self.myclient = pymongo.MongoClient(MANGO_DATABASES["HOST"], MANGO_DAT原创 2021-10-22 17:37:02 · 561 阅读 · 0 评论 -
数据库系列~删除重复数据
1.删除数据库重复数据sql1:DELETE FROM clue_industry WHERE id NOT IN (SELECT t.max_id FROM(SELECT MAX(id) AS max_id FROM clue_industry GROUP BY industry_name) AS t);clue_industry: 表名industry_name :字段名原创 2021-09-08 14:34:23 · 118 阅读 · 0 评论 -
python操作Mysql数据库返回字典格式
import pymysqlclass MysqlOperation: """操作Mysql """ def __init__(self): self.conn = pymysql.connect(host='10.210.2.80', user='root', password='test123456', .原创 2021-06-08 18:13:01 · 1109 阅读 · 0 评论 -
linux+python自动备份数据库
linux+python自动备份数据库1aospython自动化备份数据库:1.在linux上安装mysqldump:yum -y install holland-mysqldump.noarch2.编写python脚本:#!/usr/bin/python3 pythonimport pymysqlimport osimport timeTIME = time.strftime("%Y-%m-%d", time.localtime())connect = pymysql.connect原创 2021-05-28 17:33:34 · 571 阅读 · 3 评论