pycharm中如何下载json

如题所述

csv导入mysqlloaddatainfile'C:\\Users\\UserName\\Desktop\\test.csv'intotable`table`fieldsterminatedby','optionallyenclosedby'"'escapedby'"'linesterminatedby'\n';mysql导入csvselect*from`table`loaddatainfile'C:\\Users\\UserName\\Desktop\\test.csv'fieldsterminatedby','optionallyenclosedby'"'escapedby'"'linesterminatedby'\n';如果乱码,可用相关编辑器打开.csv文件,另存为utf-8的csv
温馨提示:答案为网友推荐,仅供参考
相似回答