Delete Data From MySQL Tutorial Example

How To Delete Data From MySQL Tutorial Example

Open your MySQL Query Editor then copy & paste the below code to delete data from a database table "test" in MySQL Database Server

-- How To Delete Data From MySQL Tutorial Example

DELETE FROM test;

-- that's it!! all rows of mysql database table "test" have/has been deleted
-- because there is no WHERE condition, so be careful before using it in production database
      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

How To Delete Data From MySQL Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

  1. MySQL IF() Function String Value Example
  2. MySQL IF() Function Number Value Example
  3. MySQL IF() Function Boolean Value Example
  4. MySQL strcmp() Function Number Value Example
  5. MySQL strcmp() Function NULL Value Example
  6. Aliase column name in SQL Command MySQL Example
  7. Operator precedence in SQL Command MySQL Example
  8. MySQL Stored Procedure: INSERT INTO SELECT... Example
  9. 20 steps to make CakePHP Blog Project

No comments:

Post a Comment

leave your comments here..