Top "Dbi" questions

How do I tell DBD::mysql where mysql.sock is?

Using DBD::mysql with DBI, I am getting the following error when attempting to connect to the database. DBI connect(…

mysql perl dbi

Perl DBI insert multiple rows using mysql native multiple insert ability

Has anyone seen a DBI-type module for Perl which capitalizes, easily, on MySQL's multi-insert syntax insert into TBL (col1, col2, …

mysql perl insert dbi

Determine if $sth has rows without consuming it?

With DBI is there a way to determine if an executed statement handle for a SELECT statement will return any …

perl dbi

How do I insert null fields with Perl's DBD::Pg?

I have a Perl script inserting data into Postgres according to a pipe delimited text file. Sometimes, a field is …

perl postgresql dbi

Problems with Perl DBI/DBD on OSX 10.9 Mavericks

After upgrading to OSX Mavericks I can't get DBI/DBD to run. Perl and MySQL are running fine (I can …

macos perl dbi dbd osx-mavericks

How do I check if a database row exists using DBD::mysql and Perl?

I'm working with a MySQL database and need to check if a row is already there before deciding which queries …

mysql perl dbi dbd

Which one represents null? undef or empty string

I want to insert null in a column in a table. Which one represents null? undef or empty string ''. …

perl oracle dbi

Perl DBI connect and execute timeout

At work we have a DBA who said his RAC working just fine, but the truth is it isn't. SQL …

perl oracle11g dbi

perl DBI and placeholders

I have this query select * from table where ID in (1,2,3,5...) How is it possible to build this query with the …

perl dbi

Error ORA-12154 on DBI->connect to Oracle database with Oracle Instant Client in Solaris 10

I've been pulling my hair out over this problem for two days now: I'm trying to get a perl script …

perl oracle11g dbi solaris-10 tnsnames