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

[rayapati]

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.

[ronverdonk]

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:

ALTER TABLE talbe_name MODIFY column_x BIGINT NOT NULL;

Ronald :cool:

[rayapati]

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

[ronverdonk]

You have the answer, so what else do you want???

Ronald :cool:

[rayapati]

You have the answer, so what else do you want???

Ronald :cool:

thanks for ur sujjession