yerac8 Posted January 3, 2013 Share Posted January 3, 2013 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)"); Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted January 3, 2013 Share Posted January 3, 2013 To remove all data from the table: TRUNCATE TABLE tablename Quote Link to comment Share on other sites More sharing options...
yerac8 Posted January 3, 2013 Author Share Posted January 3, 2013 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; Quote Link to comment Share on other sites More sharing options...
Jessica Posted January 3, 2013 Share Posted January 3, 2013 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. Quote Link to comment Share on other sites More sharing options...
requinix Posted January 3, 2013 Share Posted January 3, 2013 ...and TRUNCATE TABLE will delete everything - it doesn't take a WHERE. Quote Link to comment Share on other sites More sharing options...
yerac8 Posted January 10, 2013 Author Share Posted January 10, 2013 Thanks for all the replies.. Tried the TRUNCATE TABLE. It worked perfectly!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.