|
Follow the steps below to run SimpleDB queries:
-
Run
SDB Explorer
and connect with
Amazon SimpleDB account
.
-
Select the domain form drop down list located at the top of upper right panel of SDB Explorer window.
-
Write the query text below.
-
You can use operators like =, ! =, <, > <=, >=, STARTS-WITH, AND, OR, NOT, INTERSECTION AND UNION and the format of query must be
[ ‘Attribute name’ <operator > ‘Search value’ ]
For Example Domain : -
Employee
|
Item
|
Employee name
|
Employee Salary
|
|
01 |
John |
$15,00 |
|
02 |
Lee |
$ 13,00 |
-
So for
domain
Employee you can run queries like :
(1)
['Employee name' STARTS-WITH 'J']
: It will return the row whose Item is 01
(2)
['Employee Salary' = '$13, 00']
: It will return the row whose Item is 02
-
You can also run
SELECT query
and you can use select expressions like =, !=, <, > =, like, not like, between, is null, is not null.
-
Click on
Run Query
button located below the
Quick connect
button.
-
Record retrieving process will start as soon as you click Run query button.
-
Within a few seconds you will be seen all the appropriate records according to the given queries in the table below.
-
If you click Run Query button without entering query you will be seen a message as 'Please enter the text query'.
-
If you enter wrong syntax for query then you will be seen an error message as 'The specific query expression syntax is not valid'.
-
Avoid wrong entries for the sake of convenience.
|
|
|
|
|
