in reply to Re: DBD::CSV::st execute failed:
in thread DBD::CSV::st execute failed:

See https://metacpan.org/pod/DBD::File#f_ext and adjust your sql accordingly (drop the extension from tablename )

Replies are listed 'Best First'.
Re^3: DBD::CSV::st execute failed:
by Sandy_Bio_Perl (Beadle) on May 27, 2016 at 22:40 UTC

    Thank you. I have removed f_ext => ".csv/r", from the script. However, this just gives me "No result found" which I know to be wrong

[reply]
      How about, restore f_ext, but change your query? 
      select
    *
from
    newCsv
limit
   1

      [download]
[reply]
[d/l]
Re^3: DBD::CSV::st execute failed:
by Sandy_Bio_Perl (Beadle) on May 27, 2016 at 22:25 UTC

    The perl script is runSQLQuery.pl. The csv file is newCsv.csv

[reply]

In Section Seekers of Perl Wisdom