Respuestas

deleting all data from sql database

hace 12 años • actualizado por hace 12 años • 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?

Voto

Respuestas 1
Más antiguo primero
- Más reciente primero
- Más antiguo primero

hace 12 años

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"

Respuesta
|

Servicio de atención al cliente por UserEcho