I have one table. The table name is employee. I used below query.
delete department,name,bloodgroup from employee where employeeid=2;
But I am not able to delete this record alone. It is showing error. And I don't want to use update statement.
4 Answers
You can't delete single column entries with the delete SQL command. Only complete rows.
You can use the update command for that:
update employee
set department = null, name = null, bloodgroup = null
where employeeid=2;
6 Comments
MatBailie
Or, if the OP actually wants to delete the whole record...
DELETE employee WHERE employeeid = 2
Mike Sherrill 'Cat Recall'
@Dems:
DELETE FROM employee ...
swiss_knight
What if department has a not-null constraint e.g.?
juergen d
@s.k: If a record without a department is not allowed by design then you can not set it null. That is why the restriction was made by the one creating the table design
juergen d
@s.k: There is no universal default value. Maybe you should ask a specific question about your problem with some example data.
|
The above solution won't work until NOT NULL constraint is dropped(removed) to do this:
ALTER TABLE employee;
ALTER COLUMN department DROP NOT NULL;
After this You can UPDATE the table as above:
UPDATE employee SET department = null WHERE employeeid =2;
Hope this one helps Thank you!
Comments
We cannot DELETE a particular column value in SQL, we can UPDATE it.
Comments
You can delete a particular column full value of a table in the database using this command.
UPDATE 'table_name' SET 'column_name' = NULL;
Using this command you can clear all the values of a column to null
updatestatement? It's the only way to set specific column values to null