Registersql: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
| Line 5: | Line 5: | ||
Example | Example | ||
>registersql "getBerlinCustomers" "return only customers from Berlin" "select CustomerID, CompanyName, City, Phone from customers where City= | >registersql "getBerlinCustomers" "return only customers from Berlin" "select \"CustomerID\", \"CompanyName\", \"City\", \"Phone\" from customers where City='Berlin'" | ||
Revision as of 12:23, 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'"
