The DELETE command is used to delete records in a table.
Syntax:
Delete specifies which record or records that should be deleted.
Delete All Record(Be careful when you can not use the WHERE clause, ALL records will be DELETE)
As you see, we have like this "Candidate" table.
Example:
Output:
Output:
All record deleted.
Syntax:
Delete specifies which record or records that should be deleted.
DELETE FROM table_name
WHERE some_column_name=some_value
WHERE some_column_name=some_value
Delete All Record(Be careful when you can not use the WHERE clause, ALL records will be DELETE)
DELETE FROM table_name
As you see, we have like this "Candidate" table.
Example:
DELETE FROM CANDIDATE where CandidateNumber='1269911'
Output:
DELETE FROM CANDIDATE
Output:
All record deleted.
Post a Comment