GBase常用sql操作和datax gbase配置参数 | 您所在的位置:网站首页 › oppofindx4参数配置 › GBase常用sql操作和datax gbase配置参数 |
jdbcUrl:jdbc:gbase://192.168.x.y:5258/testdb 驱动下载 { "user": "root", "password": "", "address": "jdbc:gbase://192.168.1.xxxx:5258/testdb", "database": "testdb", "jdbcUrl": "jdbc:gbase://192.168.1.xxxx:5258/testdb", "driverClassName": "com.gbase.jdbc.Driver", "validationQuery": "select 1", "port": 5258 } 查看数据库 show databases; 切换数据库 use test; 查看表 show tables; 查询数据 select * from t7; 创建表 CREATE TABLE `log` ( `id` int(200) NOT NULL COMMENT '数据id', `B` varchar(30) DEFAULT NULL , `A` varchar(1024) DEFAULT NULL, `TTT` varchar(255) DEFAULT NULL, `TEST` varchar(255) DEFAULT NULL, `QWQE` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='日志'; 新增数据 INSERT INTO `log`( `B`, `A`, `TTT`, `TEST`, `QWQE`) VALUES ( '1111', '2222', '333', '4444', '5555'); { "job": { "content": [ { "reader": { "name": "rdbmsreader", "parameter": { "column": ["a","b","c","d"], "connection": [ { "jdbcUrl": ["jdbc:gbase://192.168.1.xxx:5258/test"], "table": ["test"] } ], "password": "xxxx", "username": "root", "where": "" } }, "writer": { "name": "mysqlwriter", "parameter": { "column": [ "id", "ds", "server", "time" ], "connection": [ { "jdbcUrl": "jdbc:mysql://192.168.x.xxx/xxx?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true", "table": [ "xxxx" ] } ], "password": "xxxx", "preSql": [], "session": [], "username": "xxxxx", "writeMode": "update" } } } ], "setting": { "speed": { "channel": "1" } } } } |
今日新闻 |
推荐新闻 |
专题文章 |
CopyRight 2018-2019 实验室设备网 版权所有 |