SPIDER_DIRECT_SQL
Syntax
SPIDER_DIRECT_SQL('sql', 'tmp_table_list', 'parameters')
Description
A UDF installed with the Spider Storage Engine, this function is used to execute the SQL string sql
on the remote server, as defined in parameters
. If any resultsets are returned, they are stored in the tmp_table_list
.
The function returns 1
if the SQL executes successfully, or 0
if it fails.
Examples
SELECT SPIDER_DIRECT_SQL('SELECT * FROM s', '', 'srv "node1", port "8607"');
+----------------------------------------------------------------------+
| SPIDER_DIRECT_SQL('SELECT * FROM s', '', 'srv "node1", port "8607"') |
+----------------------------------------------------------------------+
| 1 |
+----------------------------------------------------------------------+
See also
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?