Syntax
------

SPIDER_COPY_TABLES(spider_table_name, 
 source_link_id, destination_link_id_list [,parameters])

Description
-----------

A UDF installed with the Spider Storage Engine, this function copies table
data from source_link_id to destination_link_id_list. The service does not
need to be stopped in order to copy.

If the Spider table is partitioned, the name must be of the format
table_name#P#partition_name. The partition name can be viewed in the
mysql.spider_tables table, for example:

SELECT table_name FROM mysql.spider_tables;
+-------------+
| table_name  |
+-------------+
| spt_a#P#pt1 |
| spt_a#P#pt2 |
| spt_a#P#pt3 |
+-------------+

Returns 1 if the data was copied successfully, or 0 if copying the data failed.

URL: https://mariadb.com/kb/en/spider_copy_tables/