SPIDER_BG_DIRECT_SQL
You are viewing an old version of this article. View
the current version here.
Syntax
SPIDER_BG_DIRECT_SQL('sql', 'tmp_table_list', 'parameters')
Description
Executes the given SQL statement in the background on the remote server, as defined in the parameters listing. If the query returns a result-set, it sttores the results in the given temporary table. When the given SQL statement executes successfully, this function returns the number of called UDF's. It returns 0
when the given SQL statement fails.
This function is a UDF installed with the Spider storage engine.
Examples
SELECT SPIDER_BG_DIRECT_SQL('SELECT * FROM example_table', '', 'srv "node1", port "8607"') AS "Direct Query"; +--------------+ | Direct Query | +--------------+ | 1 | +--------------+
Parameters
error_rw_mode
- Description: Returns empty results on network error.
0
: Return error on getting network error.1
: Return 0 records on getting network error.
- Default Table Value:
0
- DSN Parameter Name:
erwm
See also
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.