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

  • How to drop a column from table in MySQL?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 314
    Comment on it

    Sometimes we need to drop a column that we don't need further from the table. We can do this by using DROP keyword with ALTER command.

    Syntax:

    To drop/delete the column from a table, use the following syntax:

    1. ALTER TABLE table_name
    2. DROP COLUMN column_name;

    Example: Suppose we have a table user as below:

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

    Now we want to delete the column named "age" in the "user" table. For that we use the below statement

    1. ALTER TABLE user
    2. DROP COLUMN age;

    Result: The "user" table will now look like as below:

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

    Hope this will help you :)

    mysql alter command drop column delete column 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: