Friday, January 11, 2013

MySQL convert column type from TEXT to VARCHAR()

You can convert column type from TEXT to VARCHAR() with below query.

ALTER TABLE tablename MODIFY columnname VARCHAR(X)

No comments:

Post a Comment