sql Delete Statement

[yerac8]

I am writing a php code to perform operations on a database. I want to clear all entries in the table before I start modifying it.

The line of code i have to perform that deletion is not workin. Can any body tell me what wrong?

 

 

 

$result = mysql_query("DELETE * FROM sales_matrix_new WHERE (row_id =$j_counter AND col_id =$k_counter)");

[Pikachu2000]

To remove all data from the table: TRUNCATE TABLE tablename

[yerac8]

Should it be written as

$result = mysql_query("TRUNCATE TABLE sales_matrix_new WHERE (row_id =$j_counter AND col_id =$k_counter)");

 

 

or just

TRUNCATE TABLE sales_matrix_new;

[Jessica]

You either want to clear ALL entries in the table, or you want to clear SOME with a where clause. Which is it?

 

DELETE does not allow column names or *. You delete the whole row.

 

If you were checking for errors it would help.

[requinix]

...and TRUNCATE TABLE will delete everything - it doesn't take a WHERE.

[yerac8]

Thanks for all the replies.. Tried the TRUNCATE TABLE. It worked perfectly!!