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, > value2 int, value3 int, value4 int, value5 int, value6 int, value7 int, > value8 int, value9 int, value10 int, value11 int, value12 int, value13 > int, > value14 int, value15 int, value16 int, value17 int, value18 int, value19 > int, value20 int, value21 int, value22 int, value23 int, value24 int, > value25 int, > value26 int, value27 int, value28 int, value29 int, value30 int, value31 > int, > value32 int, value33 int, value34 int, value35 int, value36 int, value37 > int, > value38 int, value39 int)' > > > The data is repetitive junk. Just: "key1", 1, 2, ,3 ..... "key2", 1, 2, > 3.... > > 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 let it go it prints all 10000 rows!! Is this due to the type of > query prepartion done from the command line interface? Maybe limits the > size of something? That doesn't make a lot of sense either though > because if I query the specific row I want it returns nothing. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users