On Wed, May 21, 2008 at 2:46 AM, Harold Wood & Meyuni Gani <
[EMAIL PROTECTED]> wrote:
> Doesn't sqlite support the truncate table command
>
> Woody
> from his pda
>
> -Original Message-
> From: Carlo S. Marcelo <[EMAIL PROTECTED]>
> Sent: Tuesday,
wrote: Doesn't sqlite support the
truncate table command
Woody
from his pda
-Original Message-
From: Carlo S. Marcelo
Sent: Tuesday, May 20, 2008 8:49 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] deleting 100,000 entries
@Barefoot and Keith,
Awesome! It too
Doesn't sqlite support the truncate table command
Woody
from his pda
-Original Message-
From: Carlo S. Marcelo <[EMAIL PROTECTED]>
Sent: Tuesday, May 20, 2008 8:49 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] deleting 100,000 entries
@Barefoot and Keit
Thanks Keith.
Carlo
- Original Message
From: Keith Goodman <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database
Sent: Wednesday, May 21, 2008 12:45:42 PM
Subject: Re: [sqlite] deleting 100,000 entries
On Tue, May 20, 2008 at 8:59 PM, Carlo S. Marcelo <[EMAIL PROTECTE
On Tue, May 20, 2008 at 8:59 PM, Carlo S. Marcelo <[EMAIL PROTECTED]> wrote:
> That means I save space right? Because the space all the original entries are
> still intact when I run the delete command? Whereas dropping table clears
> everything (since we are re-creating it)?
>
> I'm only assumin
ables thanks Gerry.
Carlo
- Original Message
From: Gerry Snyder <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database
Sent: Wednesday, May 21, 2008 11:54:45 AM
Subject: Re: [sqlite] deleting 100,000 entries
BareFeet wrote:
> Hi Carlo,
>
>
>> I want to clea
BareFeet wrote:
> Hi Carlo,
>
>
>> I want to clear the whole thing out(list)!
>>
>
> Do you mean that you want to delete all rows from the "list" table? If
> so, do this:
>
> delete from list;
Or you could drop the table and then create it again.
Gerry
__
gt;
To: General Discussion of SQLite Database
Sent: Wednesday, May 21, 2008 11:45:06 AM
Subject: Re: [sqlite] deleting 100,000 entries
Hi Carlo,
> I want to clear the whole thing out(list)!
Do you mean that you want to delete all rows from the "list" table? If
so, do this:
delete
Hi Carlo,
> I want to clear the whole thing out(list)!
Do you mean that you want to delete all rows from the "list" table? If
so, do this:
delete from list;
See the syntax pages at:
http://www.sqlite.org/lang.html
http://www.sqlite.org/lang_delete.html
Tom
BareFeet
http://www.tandb.com.au/sq
On Tue, May 20, 2008 at 8:40 PM, Carlo S. Marcelo <[EMAIL PROTECTED]> wrote:
> I run select * from list; and get loads and loads of entries:
>
>
> 81203|0|1|www.newwhitelistentry44994.com|0|0|0
> 81204|0|1|www.newwhitelistentry44995.com|0|0|0
> 81205|0|1|www.newwhitelistentry44996.com|0|0|0
> 8120
I run select * from list; and get loads and loads of entries:
81203|0|1|www.newwhitelistentry44994.com|0|0|0
81204|0|1|www.newwhitelistentry44995.com|0|0|0
81205|0|1|www.newwhitelistentry44996.com|0|0|0
81206|0|1|www.newwhitelistentry44997.com|0|0|0
81207|0|1|www.newwhitelistentry44998.com|0|0|0
11 matches
Mail list logo