[sqlite] temporay file

my query take hundreds of MB temporary file if i execute this query. why sqlite make enourmous big temporary table. my table in only 9 MB and have 12000 row. then i compare with mysql again, it's not make big temp table too much. my query is in topic "[sqlite] confusing with how to to this in

Re: [sqlite] confusing with how to to this in sqlite

ers-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rachmat Febfauza Sent: Sunday, December 28, 2008 9:13 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] confusing with how to to this in sqlite thanks simon for the explanation. after holiday, i works on how to optim

Re: [sqlite] cancel query in sqlite

I don't know What that is in the Delphi wrapper you use. === i use zeos ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] cancel query in sqlite

how to cancel query in sqlite specially in delphi, coz i execute query from delphi code. thanks. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] confusing with how to to this in sqlite

thanks simon for the explanation. after holiday, i works on how to optimize my query. actually awal1 table consist 12000 rows and akhir1 too. how to improve performance? i added index on table awal1 and akhir1 with following syntax : create index awal1i1 on

Re: [sqlite] confusing with how to to this in sqlite

= Without the group by clause the result set is: sqlite> select awal1.Code, awal1.Level, awal1.Category, awal1.Product, awal1.Location, awal1."Begin",akhir1."End", strftime("%s",akh ir1."End")-strftime("%s",awal1."Begin") as Difference from awal1, akhir1 where awal1.Code =

Re: [sqlite] confusing with how to to this in sqlite

It looks like you are using the sqlite3 shell, so experiment with .separator Have you used .help? Rgds, Simon yes i am using sqlite3 shell, i mean not to make display like mysql does, but the difference column that i want like mysql does. take a look at this different

Re: [sqlite] confusing with how to to this in sqlite

> The result should not be as you are expecting because column category > in table awal1 contain values 'FOOD' and column category in table > akhir1 contains values 'FOOD ' (an additional space character). If the > category columns (containijng 'FOOD') contain exactly the same text > then you

[sqlite] confusing with how to to this in sqlite

I have problem with executing this query in sqlite. to reconstruct problem please follow the following steps. 1. create table awal1, akhir1 and hasil1 first. CREATE TABLE awal1(Code char(5),Level varchar(8), Category varchar(50), Product varchar(60), Location varchar(50), "Begin" datetime);

[sqlite] (no subject)

I have problem with executing this query in sqlite. to reconstruct problem please follow the following steps. 1. create table awal1, akhir1 and hasil1 first. CREATE TABLE awal1(Code char(5),Level varchar(8), Category varchar(50), Product varchar(60), Location varchar(50), "Begin" datetime);

[sqlite] how to load in file and outfile

how to do load infile and into outfile like mysql does in sqlite? thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] how sqlite use index

how to make sqlite use index? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how do this stuff in sqlite

anyone can help me? - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, November 27, 2008 12:07:31 PM Subject: Re: [sqlite] how do this stuff in sqlite "Rachmat Febfauza" <[EMAIL PROTECTED]> wrote in message

Re: [sqlite] how do this stuff in sqlite

Define "don't work". Do you get an error? What's the error text? i mean it can be run but the result doesn't like mysql do. whats wrong with my query? Begin and End are keywords in SQLite (SQL is case insensitive). If you insist on naming your columns this way, you have to enclose the names in

[sqlite] how do this stuff in sqlite

i have query that don't work in sqlite but in mysql work and make good result. sqlite : table definition CREATE TABLE awal1(Code char(5),Level varchar(8), Category varchar(50), Product varchar(60),  Location varchar(50), "begin" datetime); CREATE TABLE akhir1(Code char(5),Level