0
Is there a problem changing the data type from varchar to int in mysql? I have a spreadsheet with some items that were inserted as varchar, all are numbers. The problem is that I need to do a search for bigger and smaller, however, as it is in varchar I do not know if it works. Also, I’m afraid of changing the type and having loss in the data.
If you do everything correctly you need not be afraid, just keep the varchar field and create a new one with int
– Sveen
da to use the CAST function or run a script in PHP, Java, or another language to insert into the new field
– Sveen
You can try the CONVERT
– Valdeir Psr
as @Sveen said, I didn’t need anything, just update the field. All data maintained.
– Rafael Pessoa