Re: Perl/mysql question

2003-07-30 Thread Octavian Rasnita
Hi all, I am using DBI and DBD::mysql to connect to a MySQL database from perl and I would like to get the execution time period after a query, like MySQL standard client shows. Sometimes when I work in the standard console client it tells me that there are x wornings. How can I see which are tho

Re: Perl/mysql question

2003-07-30 Thread Joel Fentin
Howell, Scott wrote: Has anyone written a perl script to get records from another database and write it to a file on mysql's LOAD DATA INFILE format? I just need some pointers in perl so a LOAD DATA INFILE will be read correctly. For example, a perl script: Select * from emp from a Progress databa

RE: Perl/mysql question

2003-07-30 Thread Dan Muey
> Has anyone written a perl script to get records from another > database and write it to a file on mysql's LOAD DATA INFILE > format? I just need some pointers in perl so a LOAD DATA > INFILE will be read correctly. You might want to check out Perl's DBI module at search.cpan.org I use that a