Here\'s a snippet of code from an sqlite database application I\'m working on: my $query = \"select * from pins\";
For regression testing i need to dump the entire contents of an SQLite database into a text file. But all references to that sort of act开发者_开发问答ivity only lead to guides using the sqlite execut
Writing a script to get SQL Server instance names from a table, then attempting to connect to each of these instances to pull back database configuration information. All database instances involved a
I have sql containing 8 table joins which takes time to fetch the data c开发者_开发知识库onsidering the amount of joins in the sql. I could create a temp table and simply the sql which might help spee
I\'m using Rails 3.0.0.rc and have installed the \'dbi\' gem inside my gemfile and 开发者_如何学Goran bundle install. But when I do the following require, it returns an error of \'no such file to load
I\'m working with a MySQL database and need开发者_如何学Python to check if a row is already there before deciding which queries to run.
DISCLAIMER -- Very new to Perl -- I need to pass a concatenated string of sessions to a prepared query which looks like this
this is my first foray into subclassi开发者_JAVA技巧ng with perl and I am wondering why I am getting this simple error...
I\'m using CentOS 5.5 Linux (same as Redhat 5.5) with stock perl v5.8.8 and have installed DBD-Pg-2.17.1 via CPAN shell and I\'m using
I\'m using Sybase::CTlib to query a Sybase server. However when I execute the following: while( $dbr->ct_results($restype) == CS_SUCCEED ) {