Delete in MySQL
| Previous | Home | Next |
This command is used to delete th e data specified in the conditions
Syntax
DELETE FROM tablename [WHERE Clause]
Example
DELETE FROM studinfo //studinfo is a tablename WHERE sid=114 ; //where condition is given
Example
DELETE FROM studinfo //studinfo is a tablename WHERE sid >111 ; //where condition is given
Note : This command should be used carefully, it will delete all the saved data whose Tablename is define.
Example
DELETE tablename
| Previous | Home | Next |