简单例子
CREATE TABLE source_table (f0 INT,f1 INT,f2 STRING) WITH ('connector' = 'jdbc','url' = 'jdbc:mysql://192.168.2.101:3306/flink_test','table-name' = 'source_table','username' = 'root','password' = 'root','lookup.cache.max-rows' = '100','lookup.cache.ttl' = '10s','lookup.max-retries' = '3','rows-per-second'='5');CREATE TABLE print_table (f0 INT,f1 INT,f2 STRING) WITH ('connector.type' = 'jdbc','connector.url' = 'jdbc:mysql://192.168.2.101:3306/flink_test','connector.table' = 'print_table','connector.username' = 'root','connector.password' = 'root','connector.write.flush.max-rows' = '1');insert into print_table select f0,f1,f2 from source_table;
