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

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: