1. App Creation Studio
  2. Питання
+1
Є відповідь

deleting all data from sql database

jenifercmartin 13 років тому • оновлено icahill (Administrator) 13 років тому • 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) 13 років тому
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"

Служба підтримки клієнтів працює на UserEcho