SPIDER_DIRECT_SQL
Sintassi
SPIDER_DIRECT_SQL('sql', 'lista_tab_temp', 'parametri')
Spiegazione
Una UDF installata con lo Storage Engine Spider. Esegue la stringa SQL sql sul server remoto, come definito in parametri. Se restituisce dei set di risultati, vengono scritti in lista_tab:temp.
La funzione restituisce 1 se la stringa SQL è eseguita con successo, 0 se fallisce.
Esempi
SELECT SPIDER_DIRECT_SQL('SELECT * FROM s', '', 'srv "node1", port "8607"');
+----------------------------------------------------------------------+
| SPIDER_DIRECT_SQL('SELECT * FROM s', '', 'srv "node1", port "8607"') |
+----------------------------------------------------------------------+
| 1 |
+----------------------------------------------------------------------+
Vedi anche
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.
