Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • How to delete data from a table in MySQL?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 1.88k
    Comment on it

    To delete data from a table we can use either DELETE or TRUNCATE.

    DELETE

    If we want to delete a record from table then we use DELETE FROM statement.

    Syntax:

    Below statement deletes rows from table on the basis of where condition, we can define any condition in the WHERE clause:

    1. DELETE FROM table_name [WHERE Clause]

    If WHERE clause is not specified with the statement then all the records will be deleted from the given table.

    Example:

    We have a table with the following values.

    1.     user
    2.  
    3. id  user_name     country   
    4. .......................................
    5. 1   John           Canada     
    6. 2   Chris          America        
    7. 3   Joy            London         
    8. 4   Jenny          Korea

    DELETE Examples

    Delete the user where id is 4:

    1.  DELETE FROM user where id = 4;

    Result

    1. user
    2.  
    3. id  user_name     country   
    4. .......................................
    5. 1   John           Canada     
    6. 2   Chris          America        
    7. 3   Joy            London

    TRUNCATE

    The TRUNCATE TABLE Statement

    When we want to delete all the records inside a table then, use the TRUNCATE TABLE statement.

    Syntax:

    1. TRUNCATE TABLE table_name;

    Example:

    The below statement deletes all the records of "user" table:

    1. TRUNCATE TABLE user;

    Hope this will help you :)

    mysql delete truncate Truncate Table delete record from table database
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: