python
cai0791
love computer
展开
-
PYTHON在mysql中新建数据库
import pandas as pd import pymysql as ps conn=ps.connect(host='localhost',port=3306,user='root',password='root@123',db='stock',charset='utf8') cursor = conn.cursor() sql='create table stock_new (sta...原创 2019-07-29 14:40:16 · 1751 阅读 · 0 评论 -
Python中mysql插入数据
import pandas as pd import pymysql as ps # state_dt='20190725' # stock_code='601330' # open='12.19' # close='12.15' # high='12.25' # low='12.00' # vol='136961.64' # amount='165811.515' # pre_close='1...原创 2019-07-29 14:45:01 · 4572 阅读 · 1 评论 -
解决 sqlalchemy 报错:(1193, "Unknown system variable 'tx_isolation'")
1出现此报错的原因是使用的mysql8.0 以前用的是:tx_isolation 现在用是:transaction_isolation a.通过升级 sqlalchemy 的方法可以解决此问题,pip install -i https://pypi.tuna.tsinghua.edu.cn/simple --upgrade sqlalchemy --ignore-installed(亲测有效...原创 2019-08-01 13:59:11 · 1357 阅读 · 0 评论 -
获取股票数据批量插入mysql
import tushare as ts #导入tushare import pandas as pd #导入pandas from sqlalchemy import c...原创 2019-08-01 14:05:31 · 467 阅读 · 1 评论