Change Varchar field to Date MySQL

Do you need to convert data from dd / mm / yyyy to correct yyy / mm / dd?

If it is possible to solve using this script directly in the bank.

UPDATE tbl_data SET data =
    DATE_FORMAT(STR_TO_DATE(data, '%d/%m/%Y'), '%Y-%m-%d') 
WHERE data LIKE '__/__/____'

I created an event and ran the above code. See if it helps. After you run the code and update the dates change the field type directly into the database, from VARCHAR to DATE

I think it's best to use the right kind, but the problem is not even being VARCHAR is the content having been written with the least relevant data before the most relevant. If I had been placed year, month and day, I would not have that problem. Databases are for storing raw data, not for storing cute texts to be displayed, this is the function of the application.

To do this you will have to take steps. First create a new temporary column of type DATE in the database. Then rotate a UPDATE to populate it with the dates. Then delete the old column and rename the new one with the old one (optionally).

UPDATE tabela SET datatmp = STR_TO_DATE(data_venda, '%d/%m/%Y')

Of course, if the application expects the old one to still exist, it will have to be dropped. But there's a problem, the new (or updated) data will only tinker with the old column. The right thing is to adapt all applications that access it to work with the new column.