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: > > <snip> > 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 > 81208|0|1|www.newwhitelistentry44999.com|0|0|0 > 81209|0|1|www.newwhitelistentry45000.com|0|0|0 > <eot> > > I want to clear the whole thing out(list)!
To remove *all* records from the table: sqlite> delete from list; _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
