MySql, is there a way to convert Integer field into Varchar without losing data?

Question

I would like to change a table's schema so that one Integer field changes to Varchar one, but keep the data (previous numbers will now be strings).

Accepted Answer

try this to alter the schema:

```
alter table table_name change col_name col_name varchar(10)
```

Solution