1. App Creation Studio
  2. Questions
+1
Résolu

deleting all data from sql database

jenifercmartin il y a 12 ans • mis à jour par icahill (Administrator) il y a 12 ans • 1
I have a sql database for the user to create and access himself. I know how to allow him to delete lines of data one at a time, but i want to know how to allow him to delete all data at once. Is that possible?
icahill (Administrator) il y a 12 ans
You would just need to alter your query for the SQL table. You could use delete and change your approach to where or you could decide to use truncate which will clear the entire table and only leave the column headers

query="TRUNCATE TABLE table_name"

Service d'assistance aux clients par UserEcho