Hi,
Given the table:
CREATE TABLE Posts (
PostID INTEGER PRIMARY KEY,
CategoryID INT NOT NULL
)
Filled up with 500,000 rows
And the index:
CREATE UNIQUE INDEX IX_Posts (CategoryID, PostID)
The query:
SELECT CategoryID, PostID
FROM Posts
ORDER BY CategoryID
LIMIT 10
Takes about 15
Look here -
http://www.sqlite.org/lang_transaction.html
LuYanJun wrote:
> Thanks, But I step the instruction fellow the hint by offcial document by
> which said that's correct(BTW forgive me my poor english ):
> http://www.sqlite.org/concurrency.html
> 4.1 Read-only transactions
> BEGIN READ_ONLY
LuYanJun <[EMAIL PROTECTED]> wrote:
Thanks, But I step the instruction fellow the hint by offcial
document by which said that's correct(BTW forgive me my poor english
): http://www.sqlite.org/concurrency.html
4.1 Read-only transactions
BEGIN READ_ONLY;
SELECT * FROM t1;
SELECT * FROM t2;
COMMIT;
Thanks, But I step the instruction fellow the hint by offcial document by which
said that's correct(BTW forgive me my poor english ):
http://www.sqlite.org/concurrency.html
4.1 Read-only transactions
BEGIN READ_ONLY;
SELECT * FROM t1;
SELECT * FROM t2;
COMMIT;
4.2 Defer write locks
BEGIN READ_INI
On 12/18/06, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote:
I was hoping there was the equivalent of Sybase's BCP program. I was
also hoping something programmatic was available, i.e., not something
from the command shell. Maybe a little background would help.
I'm planning on using the perl p
You can't use BCP to load data without some form of input file, can
you? So what could you do with BCP that you can't do by landing the
data in a CSV file and then loading it using some other tool?
I think that DRH's point was that the functionality provided by the
command line tool is not
Firman Wandayandi wrote:
Hi,
Is any possible way to know if a column is UNIQUE without "PRAGMA
index_info('')"? Seems "PRAGMA table_info('')"
doesn't returns the unique flag of column.
Thanks for advice.
Firman,
You should try pragma index_list(''). It returns a list of
all the indexes (or i
[EMAIL PROTECTED] wrote:
Guy Hindell <[EMAIL PROTECTED]> wrote:
I would like to use sqlite (v3.3.8) on a linux box (fedora core 5) to
read/write a database file in a directory which is actually on a windows
share mounted via samba/cifs. I can open the file, and read from it, but
writing pro
I was hoping there was the equivalent of Sybase's BCP program. I was
also hoping something programmatic was available, i.e., not something
from the command shell. Maybe a little background would help.
I'm planning on using the perl package DBD::SQLite. My department is a
big sybase user but becaus
Many differents on create table statements...
[EMAIL PROTECTED] a écrit :
My client has an application which uses MS-SQL CE. My app uses SQLite
3.
Does anyone know of any compatibility issues?
Thanks,
Richard
--
My client has an application which uses MS-SQL CE. My app uses SQLite
3.
Does anyone know of any compatibility issues?
Thanks,
Richard
"Anderson, James H \(IT\)" <[EMAIL PROTECTED]> wrote:
> or do I have to creation a gazillion insert statements?
>
The sqlite3 command-line shell has a ".import" command which
can be used to read CSV data. But the way this works internally
is that the command-line shell constructs an INSERT s
...or do I have to creation a gazillion insert statements?
Thanks,
jim
NOTICE: If received in error, please destroy and notify sender. Sender does not
intend to waive confidentiality or privilege. Use of this email is prohibited
when rec
Thanks for clarifying that. I think this should settle it now.
In fact when that format is used Excel will pick it up correctly as
well, so that avoids the trouble of my previous method to convert
my Interbase mmdd dates to Excel integer dates via the Julianday
function.
RBS
> [EMAIL PROTECTE
Yes, so that may settle it then.
RBS
> [EMAIL PROTECTED] wrote:
>> I think it was the date format in the SQLite table that wasn't right.
>> I had this as dd-mm-
>>
>> Doing SELECT date('2006-02-16','+1 month')
>> gives me indeed correctly 16 Feb 2006
>>
>> So does the format have to be -m
[EMAIL PROTECTED] wrote:
> I think it was the date format in the SQLite table that wasn't right.
> I had this as dd-mm-
>
> Doing SELECT date('2006-02-16','+1 month')
> gives me indeed correctly 16 Feb 2006
>
> So does the format have to be -mm-dd ?
>
Yes. That format is called ISO-86
[EMAIL PROTECTED] wrote:
I think it was the date format in the SQLite table that wasn't right.
I had this as dd-mm-
Doing SELECT date('2006-02-16','+1 month')
gives me indeed correctly 16 Feb 2006
So does the format have to be -mm-dd ?
Only if you want it to work... ;)
Martin
---
I think it was the date format in the SQLite table that wasn't right.
I had this as dd-mm-
Doing SELECT date('2006-02-16','+1 month')
gives me indeed correctly 16 Feb 2006
So does the format have to be -mm-dd ?
RBS
> [EMAIL PROTECTED] wrote:
>> Unfortunately, it looks that just adds 3
[EMAIL PROTECTED] wrote:
> Unfortunately, it looks that just adds 30 days, so 16 Feb 06 will give 18
> March 06 etc.
>
SELECT date('2006-01-16','+1 month');
yields 2006-02-16.
You must have typed something wrong.
--
D. Richard Hipp <[EMAIL PROTECTED]>
---
Unfortunately, it looks that just adds 30 days, so 16 Feb 06 will give 18
March 06 etc.
RBS
>> If you have two dates A and B, you can ask the question:
>
>> Is A more than one month after B like this:
>
>> SELECT julianday(A,'+1 month')>B ...
>
>
> Thanks; that looks exactly what I need.
>
> RB
Hi Steve,
as a possible alternative for Python you may take a look at Lua
language. www.lua.org Here is also a few webserver platform such as
Xavante. Web-pages looks as standard html pages with Lua code fragment
(similar to ASP but simpler)
Lua supports SQLite with nice library luasqlite.
In
21 matches
Mail list logo