472,328 Members | 1,715 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,328 software developers and data experts.

[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 1811
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

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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Sanjay Minni | last post by:
What is the datatype to be used for Primary Key columns for most optimised access given that - There will be a single column primary key only -...
by: Jenny | last post by:
I have a problem within a procedure I am working on. I would like to process every column in a table in a cursor. Now to my problem, I can't save a...
by: J.C. Flores | last post by:
Hello all, First of all, I must state that I'm new to SQL Server, but have been a long-time software guy for quite some time. Please excuse the...
by: SoYouKnowBrig | last post by:
Hi All, I am using Microsoft.ApplicationBlocks.Cache.CacheManager to persist a System.Data.Dataset object. This Dataset object has a DataTable...
by: gene.ellis | last post by:
Hello. I using a simply SELECT statement to retrieve some data from a SQL SERVER via an ODBC connection. I had to go from VARCHAR to TEXT because...
by: mail | last post by:
Urgent help needed! I moved an application from ASP+ACCESS to ASP+MS SQLSERVER and I have the following problem: If the join on two tables...
by: dotnetnoob | last post by:
i keep getting Object references not set to an instance of an object from this code: Private Sub EqBinding() Dim x As Integer x = 0 Do If...
by: Orchid | last post by:
How can I change a Date datatype to a Number datatype? For example, I want a date 10/31/2006 to show 1031 as Number datatype. But I don't want it...
by: John | last post by:
In my app I've created a label report (Avery 7162, 2 colums, 8 rows) with the wizzard. The report is based on a temp table that is created when the...
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.