Emptying A Table

[dkin]

How do you empty a table in mysql using php?

[Anyango]

mysql_query("truncate table TABLENAME");

[newb]

<?php

$connection = mysql_connect('localhost', 'user', 'pass');

mysql_select_db('db_name);

$sql = "TRUNCATE TABLE `table_name`";

mysql_query($sql);

mysql_close($connection);

[jatar_k]

or just

delete from tablename

that deletes all rows