almost 6 years ago
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.
To change the data type of a column in a table, use the following syntax:
ALTER TABLE table_name
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:
ALTER TABLE comments
MODIFY COLUMN comment TEXT;
Hope this will help you :)
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using