import pymysql
import sys
import tushare as ts
import pandas as pd
class Mysql:
#默认是将数据导入至本地
def __init__(self,host='localhost',user='root',password='',charset="utf-8",db=''):
assert password != '','请输入数据库密码'
assert db != '', '请输入数据库名称'
self.host=host
self.user = user
self.pwd = password
self.charset = charset
self.db = db
#连接数据库并获取操作游标
def connect(self):
print('正在连接数据库......')
try:
self.conn = pymysql.connect(host=self.host,user=self.user,passwd=self.pwd,db=self.db)
self.cursor = self.conn.cursor()
print("数据库连接成功......")
print('='*100)
except
Python将Tushare数据导入至mysql
最新推荐文章于 2023-04-18 20:39:12 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)