Re: How to use perl dbi to create a database

2010-06-29 Thread Ashish Mukherjee
http://search.cpan.org/~timb/DBI-1.611/DBI.pm#data_sources This is how you can check for existence of a database. - Ashish On Mon, Jun 28, 2010 at 2:21 PM, Sharma, Sumit sumit.sha...@aeroflex.comwrote: Hello, I am trying to use Perl to identify if a given database exists or not and if it

Re: Issue with prepared statement

2010-06-05 Thread Ashish Mukherjee
Hello, Generally, there is no gain to using bind parameters if you don't know the columns to be projected in advance in SELECT and your LIKE regex is also dynamic. It can't prepare a query execution plan and cache it for later use, since the basic constructs of your query keep changing. I am not