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
Is it possible to mass delete all records in a table
Re: Is it possible to mass delete all records in a table
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`
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: Is it possible to mass delete all records in a table
I love the new AppGini version.. just paid my upgrade fee and installed it.. WOW! Thanks Ahmad!! Great work!
Tina O'Connell
Web Dev & Appgini FAN
Web Dev & Appgini FAN
Re: Is it possible to mass delete all records in a table
You're always welcometoconnell wrote:I love the new AppGini version.. just paid my upgrade fee and installed it.. WOW! Thanks Ahmad!! Great work!
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
Re: Is it possible to mass delete all records in a table
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!
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!
Tina O'Connell
Web Dev & Appgini FAN
Web Dev & Appgini FAN
Re: Is it possible to mass delete all records in a table
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
ahh...found the "allow mass delete" checkbox in appgini.
sorry for double post!
sorry for double post!