Flink CDC中从mysql同步到mysql中 提示这个错误？

Flink CDC中从mysql同步到mysql中 提示这个错误？mysql-cdc' can only be used as a source. It cannot be used as a sink
版本是flink1.17,flink-cdc:2.21,
sql语句:
CREATE TABLE demo1 (
id INT,
name STRING,
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'mysql-cdc',
'username' = 'root',
'password' = '123456',

'table-name' = 'demo1',
'database-name' = 'flink',
'hostname' = '192.168.66.237',
'port' = '3306'
);

CREATE TABLE demo2 (
id INT,
name STRING,
PRIMARY KEY (id) NOT ENFORCED
) WITH (
'connector' = 'mysql-cdc',
'username' = 'root',
'password' = '123456',

'table-name' = 'demo2',
'database-name' = 'flink',
'hostname' = '192.168.66.237',
'port' = '3306'
);

insert into demo2 select * from demo1;