Create databases where you need them.
To select some rows from a table, use a standard SELECT query:
SELECT * from myTable WHERE column1 = 'a value'
To select specific columns from the table, just replace the asterisk with the column names:
SELECT column2, column3, column5 FROM myTable WHERE column2 LIKE 'goat%'
Data which is produced from a SELECT query is returned as a set of comma-delimited values, with the first row containing the column names.
Given the aforementioned SELECT query, the results would look something like this:
goat,this data,another column
goats,that data,a second column
goatee,their data,the last column
DBLX supports all the SQL comparators in a WHERE CLAUSE:
DBLX currently has one limitation when using the SQL WHERE clause:
ORin a WHERE clause will be evaluated from left to right.
If it is necessary to SELECT rows with a NULL value you can do this by specifying the column value as
'' in the WHERE clause. (two single quotes with no space inbetween)
To control the ordering of one of the returned columns, add the ORDER BY clause to the end of the SELECT query:
SELECT * FROM myTable WHERE column1 = 'value' ORDER BY column2 ASC
The ORDER BY clause will order content Descending by default. You can add a value to the ORDER BY clause to control the ordering. Use
ORDER BY column2 DESC to sort Descending, and
ORDER BY column2 ASC to sort Ascending.
Select queries can be nested as subselects using the WHERE [value] IN clause:
SELECT * from myTable WHERE column1 IN (SELECT column1 from otherTable where column3 < 45)
Subselects have the following required properties:
ex: WHERE col3 IN (41, 53, 61))