使用Python向mysql导.sql、.xlsx、.csv方法

最新推荐文章于 2024-12-18 10:30:44 发布

农夫的搬砖

最新推荐文章于 2024-12-18 10:30:44 发布

阅读量209

点赞数

文章标签： pandas python excel csv

本文链接：https://blog.youkuaiyun.com/hiizw/article/details/115212051

版权

import pymysql
import pandas
from subprocess import Popen
from sqlalchemy import create_engine
import pandas as pd

# 导入sql数据
    def mysql_import(self, relative_file_path):
        # sudo ln -s /usr/local/mysql/bin/mysql  /usr/local/bin
        cmd = "mysql -h'{host}' -P'{port}' -u'{user}' -p'{passwd}' -D'stat' < '{file}'".format(host=self.host, port=self.port, user=self.user, passwd=self.passwd, file=relative_file_path)
        try:
            p = Popen(cmd, shell=True)
            p.wait()
            print("成功导入SQL文件【{}】中的数据".format(