DbConsole
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%';
> 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:
- \db switch to a different database or create a new database configuration
- \config edit or delete an existing database configuration
- \lc {tablename} list the column names in a table