Page 1 of 1
Is it possible to mass delete all records in a table
Posted: 2014-06-07 06:33
by johnboy
Hi,
Using the mass deleted option in 5.30 it deletes the selected visible rows.
Is there a way to delete all rows (empty the table) at once?
Thanks
John
Re: Is it possible to mass delete all records in a table
Posted: 2014-06-07 14:58
by a.gneady
Nope. You can only delete all records displayed in the current page. If you have too many pages, better run this SQL in phpMyAdmin:
Re: Is it possible to mass delete all records in a table
Posted: 2014-06-10 15:30
by toconnell
I love the new AppGini version.. just paid my upgrade fee and installed it.. WOW! Thanks Ahmad!! Great work!
Re: Is it possible to mass delete all records in a table
Posted: 2014-06-15 16:16
by a.gneady
toconnell wrote:I love the new AppGini version.. just paid my upgrade fee and installed it.. WOW! Thanks Ahmad!! Great work!
You're always welcome
Re: Is it possible to mass delete all records in a table
Posted: 2014-06-20 13:46
by toconnell
John,
Ahmad is saying basically use your PHPMyadmin and directly in MYSql you can just drop all records from a table with that sql command he put above. With the new mass delete function if your table is showing 10 records you can only delete what you can see, those 10 records at one time. Which anymore in the application can prove dangerous. I think it is a good method. I use it with a filter.. filter out all the records I want to delete based on my criteria in the filter and then select all and mass delete.. love this new function!
Re: Is it possible to mass delete all records in a table
Posted: 2014-07-02 08:59
by ohinrichs
Can't find a mass delete function in 5.30-628. Where is it?
Re: Is it possible to mass delete all records in a table
Posted: 2014-07-02 09:52
by ohinrichs
ahh...found the "allow mass delete" checkbox in appgini.
sorry for double post!