完整示例
完整示例
CREATE TABLE orders (
order_id BIGINT,
user_id BIGINT,
amount DECIMAL(12,2),
status STRING,
created_at TIMESTAMP(3),
PRIMARY KEY (order_id) NOT ENFORCED
) WITH (
'connector' = 'mysql-cdc',
'hostname' = '10.0.0.5',
'port' = '3306',
'username' = 'cdc_ro',
'password' = '***',
'database-name' = 'app',
'table-name' = 'orders',
'server-time-zone' = 'Asia/Shanghai'
);不设 server-time-zone 时 TIMESTAMP 列常见整体偏移 8 小时，联调先把时间列对一遍。