1.4.10.2 Using the Prompt

Try selecting some information form the table testTable:

sql> SELECT * FROM testTable
Error: Table 'testTable' not found.
sql>

Unsurprisingly, this gives an error message since we haven't yet created a table. All the supported commands, including creating a table will be demonstrated in the section SQL Reference.

If you are new to SQL you should read the SQL Reference and test the examples using the interactive prompt.

To exit the Interactive Prompt type exit and press Enter:

sql> exit

C:\Documents and Settings\James\Desktop\scripts>

You will be returned to the usual command prompt.

Some test SQL commands can be sound in the file web/external/PDBC/database/external/SnakeSQL/test/test.sql. You can copy and paste the commands into the prompt and you should see output similar to that specified in the test.sql file.