Answered

deleting all data from sql database

12 year бұрын • updated by 12 year бұрын • 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?

Vote

Replies 1
Жоғарыдан ескілер
- Жоғарыдан жаңалар
- Жоғарыдан ескілер

12 year бұрын

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"

Жауап беру
|

Customer support service by UserEcho