Re: [sqlite] deleting 100,000 entries

[Gerry Snyder]

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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users