How to delete all records in a table(data type)

Need help Database
1

after uploading from a csv file, i found the data is not correct.
so I want to delete all records and upload again.
but I found no function like this sql statement: “DELETE FROM myTable”

2

The equivalent of running SQL commands is Backend workflows in Bubble. eg https://www.amliesolutions.com/bubble/basic-features/what-are-backend-workflows

Or easy way is through the Editor like this…

Screenshot 2021-10-19 at 08.59.57
Screenshot 2021-10-19 at 08.59.572262×1296 266 KB

Backend workflows can be slooooowwwwww. So if you have many 1000’s of records to delete, sometimes it’s quicker to delete the table, and recreate, and re-connect it to the elements in your app.

1 Like
3

I see. thank you. and I found that
Back-end Triggers
This feature is available on the Professional Plan and up.

the easy way is through the Editor you instructed:
I have 400 records , so I just have to repeat it 8 times. :slight_smile:

1 Like
4

Bubble needs to create a simple solution to be able to delete all records in a table.

1 Like