command you provided took
> less than a second to clear everything out, thanks!
>
> Carlo
>
> - Original Message
> From: BareFeet <[EMAIL PROTECTED]>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Sent: Wednesday, May 21, 2008 11:
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 took
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 <sqlite-users@sqlite.org>
Subject: Re: [sqlite] deleting 100
Thanks Keith.
Carlo
- Original Message
From: Keith Goodman <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
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, Carl
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
thanks Gerry.
Carlo
- Original Message
From: Gerry Snyder <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Wednesday, May 21, 2008 11:54:45 AM
Subject: Re: [sqlite] deleting 100,000 entries
BareFeet wrote:
> Hi Carlo,
>
>
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
TED]>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
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
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
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
>
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