Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

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

by jZed (Prior)
on Mar 05, 2005 at 21:01 UTC ( #436959=note: print w/replies, xml ) Need Help??


in reply to Re^2: Does DBI::Shell work for you?
in thread 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

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!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://436959]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (9)
As of 2022-08-12 15:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?