[sqlite] Two commands at once

How can I issue 2 commands to SQLite at the same time in a shell script? I want to temporarily change the separator for the returned data, something like: sqlite3 database.db ".separator " ", SELECT first,last FROM address;" But I can't get it to work. Thanks.

[sqlite] Error when installing SQLite

Recently installed QT3 in linux for my project.I need to install SQLite database,but i got the error in step 'make'.The error found in tclsqlite.c file.Try to reinstall,but i got the same error.Even i downloaded tclsqlite.c file seperatly and install it,got the same error.What should i do?

Re: [sqlite] Two commands at once

On Feb 16, 2008 12:01 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote: > How can I issue 2 commands to SQLite at the same time in a shell script? > I want to temporarily change the separator for the returned data, > something like: > sqlite3 database.db ".separator " ", SELECT first,last FROM

Re: [sqlite] SQLite Like Query Optimization

...snip... > > LIKE operators cannot use indices unless the index is case > insensitive. Use GLOB for case sensitive fields. > Richard - i'm not sure i understand "unless the index is case insensitive." How does that relate to: sqlite> create table t (a varchar(10) primary key, b, c); sqlite>

Re: [sqlite] SQLite Like Query Optimization

"Evans, Mark (Tandem)" <[EMAIL PROTECTED]> wrote: > snip... > > > > > LIKE operators cannot use indices unless the index is case > > insensitive. Use GLOB for case sensitive fields. > > > > Richard - i'm not sure i understand "unless the index is case insensitive." > How does that relate

Re: [sqlite] Two commands at once

Derrell Lipman wrote: > On Feb 16, 2008 12:01 PM, Fred J. Stephens <[EMAIL PROTECTED]> wrote: >> How can I issue 2 commands to SQLite at the same time in a shell script? >> I want to temporarily change the separator for the returned data, >> something like: >> sqlite3 database.db ".separator " ",

[sqlite] deleting syntax w/ PHP's PDO

This might be a really basic question and it might be PHP related, not SQLite, I am not sure... I know that the traditional way to do a delete would be this: DELETE FROM users WHERE ipaddress = '192.168.1.1' But I have also seen syntax where the actual statement does NOT contain the

Re: [sqlite] deleting syntax w/ PHP's PDO

On Feb 16, 2008 7:08 PM, Sam Carleton <[EMAIL PROTECTED]> wrote: > This might be a really basic question and it might be PHP related, not > SQLite, I am not sure... > > I know that the traditional way to do a delete would be this: > > DELETE FROM users WHERE ipaddress = '192.168.1.1' > > But I

Re: [sqlite] deleting syntax w/ PHP's PDO

Hi Sam, Although what you refer to applies more generally (e.g., the SQLite C API has support for it), in this case the best reference would be the PHP Manual's entry on the PDO extension: http://www.php.net/manual/en/ref.pdo.php In particular, read the section on "Prepared statements and