Author: Dale Anson
Version: 2.0.1

Running DbConsole

Simply type in SQL commands. All SQL commands must end with a semi-colon (;). Commands may span several lines (either by typing in a single long line and letting it wrap or by hitting the "Enter" key to break a long line up) and will not be executed until a semi-colon is entered. For example, you could enter the following query on 4 lines:

> select *
> from users
> where last_name
> like 'Smit%';

This query would not execute until the semi-colon had been entered and the "Enter" key pressed.

Several commands may be entered on a single line, as long as they are separated by a semi-colon. For example, you could enter:

> select * from users;select * from admins;

and you would get output as if you'd ran the two queries individually.

Several application and meta-commands are available, see the Command Reference for details. Here are a few that you might use often: