dbish (DBI::Shell 11.93 using DBI 1.51)

dbish would be a very handy tool if I could figure out how
to use it.

I've read 'perldoc DBI::Shell"

but things start badly when I type 'dbish --debug DBI:SQLite:my.db

> Unrecognised options: --debug

I worked my way down the list of advertised cmds, with the
uniform response

@DBI:SQLite:sqliteTest.dbsqliteTest.db> help /
DBD::SQLite::db prepare failed: near "count": syntax error(1) at
dbdimp.c line 269.

@DBI:SQLite:sqliteTest.dbsqliteTest.db> count pet /do
DBI::Shell: do failed: DBD::SQLite::db do failed: near "count": syntax
error(1) at dbdimp.c line 269 at
/usr/local/perl586/lib/site_perl/5.8.6/DBI/Shell.pm line 1033.

some std SQL cmds work fine, like 'select * from table1/'

but others fail, like:

@DBI:SQLite:sqliteTest.dbsqliteTest.db> show tables /
DBD::SQLite::db prepare failed: near "show": syntax error(1) at dbdimp.c
line 269.

Can anyone see what I am doing wrong, or suggest an alternate
cmd line browser that works with dbi?

note: because of permission problems, I had to install dbish in
a local directory rather than /usr/local/perl586/bin.

Thanks,

Skip

Skip Coombe
Rambus CAD Engineering
skip_coombe@rambus.com
919.960.6621
 

• dbish (DBI::Shell 11.93 using DBI 1.51) by Coombe, Skip
• Re: dbish (DBI::Shell 11.93 using DBI 1.51) by Thomas A. Lowery