Re: [sqlite] How to truncate table?

2005-07-19 Thread chan wilson
-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

Re: [sqlite] How to truncate table?

2005-07-19 Thread Puneet Kishor
baz'); sqlite> select * from t; 1|qux 2|baz sqlite> From: Puneet Kishor <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to truncate table? Date: Wed, 20 Jul 2005 00:29:27 -0500 On Jul 19, 2005, at 11:50 PM, chan wils

Re: [sqlite] How to truncate table?

2005-07-19 Thread chan wilson
Hi Puneet Kishor , Yes, you are right. I have to check out whether "DELETE FROM table;" will really set the auto imcrement primary key seed back zero. From: Puneet Kishor <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: Re: [sqlite]

Re: [sqlite] How to truncate table?

2005-07-19 Thread Puneet Kishor
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 sqlite? How about DELETE FROM table; I am assuming, by 'identity'

[sqlite] How to truncate table?

2005-07-19 Thread chan wilson
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: