Delete & Rollback

Lets delete for some unwanted data from the table

Syntax:
DELETE FROM <table_name>
WHERE <column_name_N> = <column_value_N>...;


Here:
<table name> is the table from where the date needs to be deleted
<column_name_N> is the condition for which the data needs to be deleted

Now what if you delete data by mistake. Don't worry until you do the COMMIT we can still undo the delte by the  ROLLBACK command.

Syntax:

ROLLBACK;

No comments:

Post a Comment