FLinkSQL写法kafka关联MySQL写入MySQL（proctime）

-- 创建CATALOG
CREATE CATALOG `FLINK_CATALOG` WITH('type' = 'generic_in_memory');
-- 创建DATABASE
CREATE DATABASE IF NOT EXISTS `FLINK_CATALOG`.`FLINK_DATABASE`;
--   引用数据表   [源表]
--   NodeName:[kafka]
--   NodeType:[Kafka]
--   type:Kafka
--   datasourceName:kafka70
--   tableName:`cs`
CREATE TABLE IF NOT EXISTS `FLINK_CATALOG`.`FLINK_DATABASE`.`cs` (
`id`  INT,
proctime AS PROCTIME()
)
with(
'properties.bootstrap.servers'='xx:9092',
'connector'='kafka',
'datasource.type'='Kafka',
'format'='json',
'topic'='cs',
'properties.group.id'='fxxx0',
'scan.startup.mode'='latest-offset',
);

--   引用数据表   [维表]
--   NodeName:[mysql]
--   NodeType:[JDBC]
--   type:MySQL
--   datasourceName:MySQL
--   DbName:TEST
--   tableName:`student`
CREATE TABLE IF NOT EXIST