Hi,
I am using "PRAGMA table_info(table-name);" to the the schema info of a
table, but I could not customize the returned field name, such as:
I wish "cid" to be ColumnID.
normally we do by this:
"SELECT cid AS ColumnID FROM (table-name);"
but now I could not. is there anyway work out?
Hi,
I am using "PRAGMA table_info(table-name);" to the the schema info of a
table, but I could not customize the returned field name, such as:
I wish "cid" to be ColumnID.
normally we do by this:
"SELECT cid AS ColumnID FROM (table-name);"
but now I could not. is there anyway work out?
-users@sqlite.org
Subject: Re: [sqlite] How to truncate table?
Date: Wed, 20 Jul 2005 00:40:33 -0500
On Jul 20, 2005, at 12:33 AM, chan wilson wrote:
Hi Puneet Kishor ,
Yes, you are right. I have to check out whether "DELETE FROM
table;" will really set the auto imcrement primary key
How to truncate table?
Date: Wed, 20 Jul 2005 00:29:27 -0500
On Jul 19, 2005, at 11:50 PM, chan wilson wrote:
Hi,
In MS SQL, there is a "TRUNCATE TABLE" SQL that will remove all
the records of a table and make the identity back to zero.
Is there any means to accomplish it in sq
Hi,
In MS SQL, there is a "TRUNCATE TABLE" SQL that will remove all the
records of a table and make the identity back to zero.
Is there any means to accomplish it in sqlite?
Thanks!
_
与世界各地的朋友进行交流,免费下载 MSN Messenger:
http:/
Hi,
I found this problem a long time ago, but cannot figure out why:
Everytime I put sqlite(no matter sqlite3.exe/sqlite3.dll/ other wrappers
like sqlitedb.dll/ litex dll ) in a directory that contains non-ASCII
characters, it failed to construct a connection. But it works well in those
dire
Hi All,
Please refer to phase I first.
I used the http://sourceforge.net/projects/adodotnetsqlite to do the
pressure test and see the actual performance on my PC: PIV 3.0, 1G RAM,
win2003 server(Simplifed Chinese)+vs.net2003, with unicode characters:
I slightly modified the official test: the
Hi All,
I used the http://sourceforge.net/projects/adodotnetsqlite to do the
pressure test and see the actual performance on my PC: PIV 3.0, 1G RAM,
win2003 server(Simplifed Chinese)+vs.net2003, with unicode characters:
I slightly modified the official test: the first field content and row
c
Well, please allow me to congratulate to the release of 3.2.0 and many
thanks to you guys!
I was wondering whether it might be ALTER TABLE DROP/RENAME COLUMN in next
release?
_
与世界各地的朋友进行交流,免费下载 MSN Messenger:
http://messenger.ms
The following link is dead!
http://www.sqlite.org/sqlite3-3.2.0.bin.gz
sqlite3-3.2.0.bin.gz
(201503 bytes) A statically linked command-line program for accessing and
modifing SQLite databases. See the documentation for additional information.
_
Hi,
I was wondering there is a roadmap of SQLite since many users are
concerning what will the upcoming SQLite look like. :)
_
与世界各地的朋友进行交流,免费下载 MSN Messenger:
http://messenger.msn.com/cn
11 matches
Mail list logo