A field in the table with varchar storage time, now I want to store the field into the data types, I redesigned table to modify the fields, but found in the table is stored time format is not correct data, how to do... Data about article 5 w...

CodePudding user response:

To put the format wrong, find out first, and see what rule,

CodePudding user response:

1. The field first format, if implemented, whether the data is normal
2. Insert a to_date conversion to the field of querying data into a temporary table
3 to change the original data format, the data in the temporary table surface insert new data back

CodePudding user response:

Have data, not directly modifying the original column type, can be increased by adding a column or virtual columns, or temporary table, get rid of abnormal data and then take transformation