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

  • How to change the datatype of a column in MySQL?

    @babita.dhami
    Recommendations Offline Message

    • 0
    • 1
    • 0
    • 1
    • 0
    • 0
    • 0
    • 0
    • 597
    Comment on it

    Sometimes we need to change the data type of a column in a table. We can do this by using Modify keyword with ALTER command.

    Syntax:

    To change the data type of a column in a table, use the following syntax:

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

    Example: Suppose you have a column "comment" as varchar in comments table and you want to change it's datatype to text then you can do this by using below command:

    1. ALTER TABLE comments
    2. MODIFY COLUMN comment TEXT;

    Hope this will help you :)

    mysql alter modify change datatype of a mysql table column
    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: