I use DBD::SQLite as my database and I am wondering if there is any function
that checks the existence of a table?
Or, how to list all the tables in a SQLite database using DBI?
Thanks a lot!
Yu Wang xiaohuwang at hotmail.com writes:
I use DBD::SQLite as my database and I am wondering if there is any function
that checks the existence of a table?
Or, how to list all the tables in a SQLite database using DBI?
Thanks a lot!
Solved
$dbh-tables(undef, undef, 'table_name',
It is interesting to me, how can be faster storing files on disk
versus database. If I have many pictures in database overall
db performance is slower?
Blob access tends to be less effecient due to
buffering and data transfer issues; huge tables
with images require more space and tend to be
I just want the info describing the table that I can see in sqlplus.
my $typz =
q{
select
column_name,
data_type
from
use_tab_columns
where
table_name = ?
};
my $sth = $dbh-prepare( $typz );
...
my $table = ... ;
my %name2type =
do
{
eval
{
-- Robert [EMAIL PROTECTED]
This is my hash structure:
Veterans Day = {
date= '2005',
type= 'US',
federal = 'true',
active = 'true',
},
Would I just use a placeholder (?) in my statement and pass it in via
that? It will be in a loop as I have quite a few.
-- Robert [EMAIL PROTECTED]
This is my hash structure:
Veterans Day = {
date= '2005',
type= 'US',
federal = 'true',
active = 'true',
},
Would I just use a placeholder (?) in my statement and pass it in via
that? It will be in a loop as I have quite a few.