mysql迁移模板（datax迁移模板）

{
    "content":[
        {
            "reader":{
                "name":"mysqlreader",
                "parameter":{
                    "connection":[
                        {
                            "jdbcUrl":[
                                "jdbc:mysql://172.0.0.1:3306/nrvsp?characterEncoding=utf8"
                            ],
                            "querySql":[
                                "select id,company_id,license_id,vehicle_no,logout_time,longitude,latitude,encrypt,reserved,insert_time,address from operate_logout where logout_time >= 20230300000000 and logout_time < 20230322240000"
                            ]
                        }
                    ],
                    "password":"**********",
                    "username":"root"
                }
            },
            "writer":{
                "name":"mysqlwriter",
                "parameter":{
                    "column":[
                        "id",
                        "company_id",
                        "license_id",
                        "vehicle_no",
                        "logout_time",
                        "longitude",
                        "latitude",
                        "encrypt",
                        "reserved",
                        "insert_time",
                        "address"
                    ],
                    "connection":[
                        {
                            "jdbcUrl":"jdbc:mysql://172.0.0.1:3306/nrvsp?characterEncoding=utf8",
                            "table":[
                                "operate_logout_202303"
                            ]
                        }
                    ],
                    "password":"**********",
                    "username":"root",
                    "writeMode":"replace"
                }
            }
        }
    ],
    "setting":{
        "errorLimit":{
            "percentage":0.02,
            "record":0
        },
        "speed":{
            "channel":"1"
        }
    }
}