William The Mash Up Rowe
Reputation: 11
Changing the column from varchar to int
Hiya I am new to mySQL and picking it up relatively quickly.
However I needed to change the column from varchar to INT. 
can someone help please?
Upvotes: 0
Views: 3196
Answers (1)
Nerdi.org
Reputation: 923
ALTER TABLE tablename MODIFY columnname INTEGER;
This is the SQL to do it.
Upvotes: 2
Related Questions
- How to change the type of a particular row/cell from int to varchar
- Converting varchar to int using phpmyadmin
- Casting varchar to int in mysql
- How can I change "int" into "varchar" in mySQL database without problems in php code?
- SQL CAST(int as varchar) throws error
- How to cast varchar into int properly?
- MySQL convert column datatype from VARCHAR to INT
- Convert varchar to integer
- Change MYSQL INT Value
- mysql how do I change the column id from varchars to ints and autoincreasing?