469,926 Members | 1,497 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.

How to change the datatype of coloum in mysqlcc GUI tool

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
Oct 30 '06 #1
2 3554
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:
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:
Oct 30 '06 #2
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
Oct 31 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Andreas | last post: by
4 posts views Thread by willjay | last post: by
reply views Thread by Adnaan | last post: by
reply views Thread by Vittorio Zuccalà | last post: by
4 posts views Thread by J.C. Flores | last post: by
7 posts views Thread by dotnetnoob | last post: by
reply views Thread by =?Utf-8?B?VmFubmk=?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.