代码拉取完成,页面将自动刷新
类型:reader
名称:mysqlWriter
MySQL 5.X
insert into
或者 replace into
或者 ON DUPLICATE KEY UPDATE
语句。其中当写入模式为update和replace时,默认采用主键作为唯一索引{
"job" : {
"content" : [ {
"mysqlReader1" : {
"type" : "reader",
"pluginName" : "mysqlReader",
"parameter" : {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student",
"column": [
{
"name": "id",
"type": "id"
},
{
"name": "name",
"type": "varchar"
},
{
"name": "sex",
"type": "int"
}
]
}
},
"mysqlWriter2" : {
"type" : "writer",
"pluginName" : "mysqlWriter",
"parameter" : {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student1",
"column" : [ "id", "name", "sex" ],
"writeMode" : "INSERT"
}
}
} ],
"setting": {
"name": "myJob",
"speed": {
"channel": 1
},
"restore": {
"isRestore": false
}
}
}
}
{
"job" : {
"content" : [ {
"mysqlReader1" : {
"type" : "reader",
"pluginName" : "mysqlReader",
"parameter" : {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student",
"column": [
{
"name": "id",
"type": "id"
},
{
"name": "name",
"type": "varchar"
},
{
"name": "sex",
"type": "int"
}
]
}
},
"mysqlWriter2" : {
"type" : "writer",
"pluginName" : "mysqlWriter",
"parameter" : {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student1",
"column" : [ "id", "name", "sex" ],
"writeMode" : "UPDATE"
}
}
} ],
"setting": {
"name": "myJob",
"speed": {
"channel": 1
},
"restore": {
"isRestore": false,
"restoreColumnName": "",
"restoreColumnIndex": 0
}
}
}
}
{
"job" : {
"content" : [ {
"mysqlReader1" : {
"type" : "reader",
"pluginName" : "mysqlReader",
"parameter" : {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student",
"column": [
{
"name": "id",
"type": "id"
},
{
"name": "name",
"type": "varchar"
},
{
"name": "sex",
"type": "int"
}
]
}
},
"mysqlWriter2" : {
"type" : "writer",
"pluginName" : "mysqlWriter",
"parameter" : {
"jdbcUrl" : "jdbc:mysql://0.0.0.1:3306/database?useSSL=false",
"username" : "username",
"password" : "password",
"table" : "student1",
"column" : [ "id", "name", "sex" ],
"writeMode" : "REPLACE"
}
}
} ],
"setting": {
"name": "myJob",
"speed": {
"channel": 1
},
"restore": {
"isRestore": false
}
}
}
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。