[In the message "Re: [sqlite] 1-way replication best practices?" on Sep 28,
11:29, Dan Kennedy writes:]
> On Thu, 2007-09-27 at 14:26 -0700, Cyrus Durgin wrote:
> > hi,
> >
> > i'm using sqlite3 in a small project that will run on multiple servers.
> > only one of the instances will be read-write
[In the message "Re: [sqlite] Re: Re: how do i declare and use variables in
sqlite?" on Aug 3, 11:47, "Paul Harris" writes:]
> > >> create temporary table vars (name text, value something);
> > >> --
> > >> insert into vars set name="x", value=0;
> > >> --
> > >> ... where something = (select valu
[In the message "[sqlite] Re: how do i declare and use variables in sqlite?" on
Aug 2, 18:22, "Igor Tandetnik" writes:]
> Chase <[EMAIL PROTECTED]> wrote:
> > how do i declare and use variables in sqlite?
>
> You don't. You declare and use variables in whatever program you write
> that runs SQLi
[In the message "[sqlite] What about with LAST_INSERT_ROWID() ?" on Jun 22,
15:09, litenoob writes:]
>
> Hmm.. don't know sed or awk, but I suppose this weekend would be a good time
> to learn!
>
> Alright, going along with this, is there a better way to get the last row id
> inserted? This is
[In the message "[sqlite] Capturing output from SQLlite with variables in a
BASH script" on Jun 22, 13:02, litenoob writes:]
>
> Hi, I'm wondering how to write a BASH script that will capture my SQLite
> output.
>
> I can do it for a single line with something like this:
>
> somevar=`sqlite3 db
[In the message "[sqlite] --prefix" on May 29, 13:11, "Smith1, Robert E"
writes:]
> Hi,
>
> I am trying to install sqlite3 on Sun Solaris 2.8. I am not root so I
> cannot install to /usr/local. I start configure with
> --prefix=/ptmp/usr/localto try to get it to install to a different
> dir
6 matches
Mail list logo