Thread: Delete values in single a row without using DELETE keyword.

I don't know whats going on here...
Whether can we delete a single row of table or not?
Finalize the answer...

Yes ,we can we delete a single row of table by using delete command not truncate.

You cannot delete a single row without using the delete command. By using truncate you can delete all the rows in a table. But you can update the specified row by null values without using delete command using the below query. But logically a row will be there.

update 'tablename' set value=null where 'any unique id'