Hi James,
> / > sqlite3 test.db `select name from PerfTest1 where name =
> "key5000"'
>
> does work. I know this because if I query for "key500" I get back
> that row.
It may work, but it's still wrong ;-) You should use single quotes for
literals, which is correct SQL syntax. SQLite
For SQL it needs to be 'key5000' not "key3000".
James Kimble wrote:
> On the command line:
>
> / > sqlite3 test.db `select name from PerfTest1 where name = "key5000"'
>
> does work. I know this because if I query for "key500" I get back that
> row. It's not blanks either because if I
> do:
>
James Kimble wrote:
> It's not blanks either because if I
> do:
>
> where name link "key1%"
>
> I only get rows prior to "key199".
James can you try this to check the names?
select ':' || name || ':' from PerfTest1
where length(name) != length(trim(name));
It should display
On the command line:
/ > sqlite3 test.db `select name from PerfTest1 where name = "key5000"'
does work. I know this because if I query for "key500" I get back that
row. It's not blanks either because if I
do:
where name link "key1%"
I only get rows prior to "key199". Very weird. I did
An SQL literal uses single quotes
[EMAIL PROTECTED] wrote:
> I created a 40 column table with 10,000 rows as a test database
> for a reader and a writer process to bang on (performance proof).
>
> The table is as so:
>
> sqlite3 test.db 'create table PerfTest1 (name varchar(20), value1 int,
>
On Fri, 7 Mar 2008 14:34:53 -0500 (EST), you wrote:
> sqlite3 test.db `select name from PerfTest1 where name = "key5000"'
In SQL, a string should be delimited with single
quotes, not double quotes.
Try:
sqlite3 test.db "select name from PerfTest1 where name
= 'key5000' "
or
echo "select name
[EMAIL PROTECTED] wrote:
>
> What's driving me mad is that when I do a select from the command line
> like so:
>
> sqlite3 test.db `select name from PerfTest1 where name = "key5000"'
>
> 0 rows are returned. However if I do a simple:
>
> sqlite3 test.db 'select name from PerfTest1'
>
> and just
I created a 40 column table with 10,000 rows as a test database
for a reader and a writer process to bang on (performance proof).
The table is as so:
sqlite3 test.db 'create table PerfTest1 (name varchar(20), value1 int,
value2 int, value3 int, value4 int, value5 int, value6 int, value7 int,
8 matches
Mail list logo