[SOLVED] Clear Every Record From A Database?

[stormx]

Is their a script to clear all the records in a database, I have some user history that regualy builds up on a table, I was thinking of putting it on a cron and basically clearing it all out every 24 hours.

 

Is this possible?

 

Thanks

[lonewolf217]

delete from <table name> where <column name> like '%'

 

will work if there is any column with varchar content

[thebadbad]

<?php
mysql_query("TRUNCATE TABLE `table_name`");
?>

 

Clears the table "table_name".