mysql question
Posted: Thu Apr 10, 2008 11:06 am
Hello,
I have an app that does a load data infile into a mysql table but one of the columns in the file is formatted mm/dd/yyyy (04/04/2008) and i would like it to be in the standard yyyy-mm-dd (2008-04-04) format. There are thousands of records and what is the most efficient way of changing the format?
Thank you so much!
-R
I have an app that does a load data infile into a mysql table but one of the columns in the file is formatted mm/dd/yyyy (04/04/2008) and i would like it to be in the standard yyyy-mm-dd (2008-04-04) format. There are thousands of records and what is the most efficient way of changing the format?
Thank you so much!
-R