Registersql: Difference between revisions

From Data Islands
(Created page with "We can register a sql with using registersql command (Syntax : registersql "sqlname" "description" "sql statement" <ENTER>) Example >registersql")
 
No edit summary
Line 1: Line 1:
We can register a sql with using registersql command (Syntax : registersql "sqlname" "description" "sql statement" <ENTER>)
We can register a sql with using registersql command.
 
(Syntax : registersql "sqlname" "description" "sql statement" <ENTER>)


Example
Example


>registersql
>registersql "getBerlinCustomers" "return only customers from Berlin" "select CustomerID, CompanyName, City, Phone from customers where City="Berlin"

Revision as of 10:20, 30 September 2024

We can register a sql with using registersql command.

(Syntax : registersql "sqlname" "description" "sql statement" <ENTER>)

Example

>registersql "getBerlinCustomers" "return only customers from Berlin" "select CustomerID, CompanyName, City, Phone from customers where City="Berlin"