Is it possible to mass delete all records in a table

[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

[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:

Code: Select all

delete from `tablename`

[toconnell]

I love the new AppGini version.. just paid my upgrade fee and installed it.. WOW! Thanks Ahmad!! Great work!

[a.gneady]

I love the new AppGini version.. just paid my upgrade fee and installed it.. WOW! Thanks Ahmad!! Great work!

You're always welcome

[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!

[ohinrichs]

Can't find a mass delete function in 5.30-628. Where is it?

[ohinrichs]

ahh...found the "allow mass delete" checkbox in appgini.

sorry for double post!