Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Sql-remove MySQL remove

Related Tutorials


 
 

Share on Google+Share on Google+

MySQL remove

Advertisement
We can use MySQL Delete statement to implement the removal on the database.

MySQL remove

     

We can use MySQL Delete statement to implement the removal on the database. If you want to remove any record from the MySQL database table then you can use MySQL Delete From. Here in this section we will describe how you can use Delete From in your MySQL query to remove records. Syntax is as given below :

 

 

 

 

 

Syntax :

 DELETE from table [ WHERE clause ];

WHERE clause is used when you want to perform query on some specific data records. If we don't use WHERE it will remove all records from the database table. In WHERE clause we can provide some specific condition, based on which query would be resulted. 

Explanation :

Before firing the query we must have one or more table in any database. For our example we have created a table "users", for this table structure is as given below :

Query
CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) default NULL,
  `password` varchar(50) default NULL,
  `email` varchar(50) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*Data for the table `users` */
insert  into `users`(`id`,`username`,`password`,`email`)
 values (1,'Ankur','ankur','ankur@yahoo.com'),
(2,'Vinay','vinay','vinay@yahoo.com');
mysql> select * from users;
Output
+----+----------+----------+-----------------+
| id | username | password | email           |
+----+----------+----------+-----------------+
|  1 | Ankur    | ankur    | ankur@yahoo.com |
|  2 | Vinay    | vinay    | vinay@yahoo.com |
+----+----------+----------+-----------------+
2 rows in set (0.00 sec)

Now on this table we can execute query for delete . Here we will remove all information of the user with the id value 2.

Query  
mysql> DELETE from users where users.id = 2;
Query OK, 1 row affected (0.01 sec)
mysql> select * from users;
Output
+----+----------+----------+-----------------+
| id | username | password | email           |
+----+----------+----------+-----------------+
|  1 | Ankur    | ankur    | ankur@yahoo.com |
+----+----------+----------+-----------------+
1 row in set (0.00 sec)

As you can see in output that it has removed the record with the id value 2.

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 20, 2009

Related Tutorials

Discuss: MySQL remove  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com