Delete Specific Rows Data From MySQL Tutorial Example

How To Delete Specific Rows Data From MySQL Tutorial Example

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

-- How To Delete Specific Rows Data From MySQL Tutorial Example

DELETE FROM test WHERE TestName='Noor.Hasan';

-- that's it!! all rows of mysql database table "test" have/has been deleted
-- whose TestName value is "Noor.Hasan"
      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

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

 

Related Tutorial Examples

  1. MySQL IFNULL() Function Boolean Example
  2. MySQL IFNULL() Function NULL Value Example
  3. MySQL IF() Nested Function Example
  4. MySQL IF() Function NULL Value Example
  5. MySQL IF() Function Datetime Value Example
  6. Parentheses in SQL Command MySQL Example
  7. How to Find MySQL Stored Procedure or Function Information
  8. How To Find MySQL SERVER VERSION Information
  9. 20 steps to make CakePHP Blog Project

No comments:

Post a Comment

leave your comments here..