随笔分类 -  MySQL Export & MySQL Inport

摘要:整理个Python3导出MySQL查询数据d的脚本。 Python依赖包: pymysql xlwt Python脚本: #!/usr/bin/env python # -*- coding: utf-8 -*- # # FileName: # Desc: # Author: # Email: # 阅读全文
posted @ 2019-12-21 20:17 TeyGao 阅读(1067) 评论(0) 推荐(0) 编辑
摘要:LOAD DATA INFILE导入数据 语法: LOAD DATA 命令中的默认值:FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\'LINES TERMINATED BY '\n' STARTING BY '' 文件参数: LOAD 阅读全文
posted @ 2019-04-01 22:13 TeyGao 阅读(293) 评论(0) 推荐(0) 编辑
摘要:SELECT INTO OUTFILE语法格式: 在将选择的记录导出到.csv文件时,出现提示“The MySQL server is running with the --secure-file-priv option so it cannot execute this statement”。解决 阅读全文
posted @ 2019-04-01 21:14 TeyGao 阅读(3585) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示