How do I convert a variable in my mysql table that was originally created as an integer to a varchar. What is the exact syntax that I need?
I thought the variable was originally going to be all numbers but now there is a need for letters so I need to change the variable type.
You just need to use the alter command to change the type of the column, eg -
alter table mytable modify mycolumn varchar not null
(or whatever the column needs to be)
Thanks, worked great!
