A
A
Alexander2017-01-20 14:35:29
MySQL
Alexander, 2017-01-20 14:35:29

Will changing the data type of a column in a MySQL database pass without problems?

There is a column in the MySQL database with the TEXT type, where a maximum of 10 digit numbers is written all the time and nothing more. There was a question of change of data type of a column on INT. Nothing will fly? Will all strings with numbers turn into numbers?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
d-stream, 2017-01-20
@d-stream

Might as well fly.
For example, somewhere in a couple of lines a non-number is inserted
Or somewhere this field is used in string expressions

K
kpa6uu, 2017-01-20
@kpa6uu

I checked it according to your scenario on a local basis, it normally converted to a number

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question