How to change the datatype of coloum in mysqlcc GUI tool

[rayapati]

hi all,

i had created a table using mysqlcc GUI toolwith datatype varchar now i want to change the datatype into integer. is it possible to me to change the datatype in mysqlcc GUI tool of a coloum and can i know what is the procedure tochange it .

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:

You already had that question answered, see
http://www.thescripts.com/forum/post2168876-2.html
in your previous thread with the same title.

So it is simply typing the ALTER TABLE ... in your MySQLCC command entry area and you are set. You must, however, do read the MySQL documentatiion on the ALTER TABLE command! We cannot do that for you. What is it that you don't understand in that answer? Your reply to it was that you understood!

Ronald :cool:

[rayapati]

You already had that question answered, see
http://www.thescripts.com/forum/post2168876-2.html
in your previous thread with the same title.

So it is simply typing the ALTER TABLE ... in your MySQLCC command entry area and you are set. You must, however, do read the MySQL documentatiion on the ALTER TABLE command! We cannot do that for you. What is it that you don't understand in that answer? Your reply to it was that you understood!

Ronald :cool:

thanks for your reply in previous thread i have not mentioned the mysqlcc GUI tool thats why i had the doubt.

thanks