There's also the DBI shell: dbish.
dbish dsn user pass < file.sql
Tim.
On Sun, Sep 22, 2002 at 12:09:06AM +0200, Bart Lateur wrote:
> On Thu, 19 Sep 2002 15:10:50 -0700 (PDT), Arvind Raina wrote:
>
> >My requirement is to execute a set of sql statements which are stored in a file .
> >
> >I wanted to know if there is any method of doing the same using dbi .
> >
> >If not can you suggest some methods of doing the same.
>
> What database? If it's mysql, the easiest way would be to do
>
> mysql mydb <myfile
>
> from the command line (likely with command line options -u for username
> and -p for password). I don't understand why you'd need the involvement
> of DBI, at all.
>
> --
> Bart.
