
- Forum
- Databases
- SQL Delete values in single a row without using DELETE keyword.
-
Re: Delete values in single a row without using DELETE keyword.
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'
-
Junior Member
Re: 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...
-
Re: Delete values in single a row without using DELETE keyword.
Yes ,we can we delete a single row of table by using delete command not truncate.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules