打开datax文件目录下job文件
在job目录下新建 csv_to_mysql.json 内容如下: (注意path,应为本地csv文件所在地址,)
{
"job": {
"content": [
{
"reader": {
"name": "txtfilereader",
"parameter": {
"path":["D:/data_csv/test.csv"],
"encoding":"gbk",
"splitPk": "",
"column": ["*"],
"skipHeader":"true"
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "root",
"password": "root",
"column": ["*"],
"connection": [
{
"jdbcUrl": "jdbc:mysql://127.0.0.1:3306/books?useUnicode=true&characterEncoding=utf8&autoReconnect=true",
"table": ["test"]
}
]
}
}
}
],
"setting": {
"speed": {
"byte":-1,
"channel":10,
"record":-1,
"batchSize":2048
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
}
}
}
最后启动脚本文件,执行脚本完毕.
