Converting data type in MySQL
I am attempting to clean up a database in mysql. I downloaded the excel file into mysql and am now trying to change the date column from data type text to data type datetime. I run the following query:
I am attempting to clean up a database in mysql. I downloaded the excel file into mysql and am now trying to change the date column from data type text to data type datetime. I run the following query: