469,926 Members | 1,524 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

[SOLVED] how to change the datatype of a colum which is already declared

hi all,

i am newly joined to these forum, i had doubt in mysql programming i had created a table with some colums giving the datatype as varchar now i want to change it to the interger datatype how can i change the datatype of that already created coloums. please give reply as soon as possible.

thank you.
Oct 28 '06 #1
4 1746
ronverdonk
4,258 Expert 4TB
Get yourself acqainted with and read the MySQL documentation, about ALTER TABLE command at http://dev.mysql.com/doc/refman/4.1/en/alter-table.html

Probaly get you something like:
Expand|Select|Wrap|Line Numbers
  1. ALTER TABLE talbe_name MODIFY column_x BIGINT NOT NULL;
Ronald :cool:
Oct 28 '06 #2
hi

how to change the datatype in a mysqlcc GUI tool. i had created a table in mysqlcc GUI tool with the datatype as varchar now i want to change it to integer. how can i do it in a mysql GUI tool.

thank you
Oct 28 '06 #3
ronverdonk
4,258 Expert 4TB
You have the answer, so what else do you want???

Ronald :cool:
Oct 28 '06 #4
You have the answer, so what else do you want???

Ronald :cool:
thanks for ur sujjession
Oct 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Sanjay Minni | last post: by
1 post views Thread by Jenny | last post: by
4 posts views Thread by J.C. Flores | last post: by
7 posts views Thread by dotnetnoob | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.