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
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
Rachmat,
I also noted that one of your queries includes:
time_to_sec(timediff(akhir1.End, awal1.Begin))
I think time conversion routines are part of each database vendor's
implementation -- and not part of the sql standard, so you'll need to
convert to the time routines provided in sqlite
"Rachmat Febfauza" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> i have query that don't work in sqlite but in mysql work and make
> good result.
Define "don't work". Do you get an error? What's the error text?
> CREATE TABLE hasil1 (Code char(5), Level vachar(8), Category
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
5 matches
Mail list logo