Re^3: Does DBI::Shell work for you?

> But how would I get back out to the previous view, to get
> the list of databases again?

/connect then enter

>Are there ways other than the native SQL commands
>(show tables; show columns from tablename) to display
>the schema(s)?

/col_info /table_info etc. ... type /help and press enter for a list

> Can I load data into variables and look at them?

Yes, you can, though I forget whether that's something I had to patch.

>I'm just not sure how to submit shell commands other than 
> SQL statements, executed as soon as the semicolon gets 
> entered.

type a forward slash, the command, then press enter

Comment on Re^3: Does DBI::Shell work for you?

Replies are listed 'Best First'.
Re^4: Does DBI::Shell work for you? by saintmike (Vicar) on Mar 05, 2005 at 22:42 UTC
That was the missing piece! It's hard to believe, but the man page indeed doesn't mention it. Thanks for your help!	[reply]