cc:
Sent by: Subject: Re: [sqlite] Multiple
Tables on one Flat File
[EMAIL PRO
The sqlite_master table keeps the sql used to create the table automatically.
check out
select * from sqlite_master;
On 4/14/05, Eric Bohlman <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > I ended up creating a %dbh hash with $table as the index along with one
> > Operating System
[EMAIL PROTECTED] wrote:
I ended up creating a %dbh hash with $table as the index along with one
Operating System file for each table.
I was hoping there was a way not to create so many Operating System files
because of the extra Administration they require.
can you think of any way around this?
I
[EMAIL PROTECTED] wrote:
Eric:
thank you for your reply.
I ended up creating a %dbh hash with $table as the index along with one
Operating System file for each table.
I was hoping there was a way not to create so many Operating System files
because of the extra Administration they require.
can
TED]To:
sqlite-users@sqlite.org
lobal.net> cc:
Subject: Re: [sqlite] Multiple
D. Richard Hipp wrote:
Not only CREATE statements, but also DROP and VACUUM statements
will also invalidate all previously prepared statements. Once a
prepared statement is invalidated, it must be prepared again.
And also ALTER TABLE.
On Wed, 2005-04-13 at 17:59 -0500, Eric Bohlman wrote:
> [EMAIL PROTECTED] wrote:
>
> > I am running into a situation that does not make sense.
> > I have allocated a flat file under the Operating System as follows (notice
> > that autocommit is off):
> > $dbh = DBI->connect('dbi:SQLite:' .
[EMAIL PROTECTED] wrote:
I am running into a situation that does not make sense.
I have allocated a flat file under the Operating System as follows (notice
that autocommit is off):
$dbh = DBI->connect('dbi:SQLite:' . $dbms_file , "", "",
{ RaiseError => 1,AutoCommit =>
Follow up:
If I create multiple $dbh as in $dbh{$tables}, and point each to a
different Operating System (O.S.) flat file, then I am OK.
LOOP-for-tables:
$dbh{$tables} = DBI->connect('dbi:SQLite:' . $dbms_file . $table , "",
"",
{ RaiseError => 1,AutoCommit => 0 });
9 matches
Mail list logo
