MySQL

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