copy from 用户名/用户密码@连接名 to 用户名/用户密码@连接名 replace 目标表名(目标表字段1) using select 源表字段1 from 源表名;如: copy from system/manager@test to system/manager@ replace table_b(name) using select name from table_a;
应该是这样,刚才少写了一个连接名 copy from system/manager@test to system/manager@test replace table_b(name) using select name from table_a;
copy from system/manager@test to system/manager@ replace table_b(name) using select name from table_a;
copy from system/manager@test to system/manager@test
replace table_b(name) using select name from table_a;