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

  • How to add a column into a table in MySQL?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 307
    Comment on it

    Sometimes we need to add a column that we require into the table. We can do this by using ADD keyword with ALTER command.

    Syntax:

    To add a column into a table, use the following syntax:

    1. ALTER TABLE table_name
    2. ADD COLUMN column_name datatype;

    Example: Suppose we have a table user as below:

    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

    Now we want to add the column named "age" into the "user" table.

    We use the following statement:

    1. ALTER TABLE user
    2. ADD COLUMN age int(11);

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

    1. id  user_name     country      age
    2. ..................................
    3. 1   John           Canada    
    4. 2   Chris          America     
    5. 3   Joy            London      
    6. 4   Jenny          Korea
    mysql alter add column into 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: