...
Queries Supported in the 'Query' Mode Anchor sup sup
| sup | |
| sup |
Currently, only basic SELECT, INSERT, UPDATE and DELETE queries are supported by the 'Query' mode. Shown below are few example queries.
Sample 1:
| Code Block |
|---|
SELECT customerNumber, customerName, phone, state, country FROM customers |
...
| Code Block |
|---|
DELETE FROM customers WHERE customerNumber=? |
You can also create new sheets in the Excel or drop existing sheets.
Sample 5:
| Code Block |
|---|
CREATE SHEET ProductCategories (ProductCode, Category) |
Sample 6:
| Code Block |
|---|
DROP SHEET ProductCategories |
| Excerpt | ||
|---|---|---|
| ||
Instructions to create a data source from a Microsoft Excel sheet in WSO2 products. |