Quickly add a copy of a column to a MySQL table

I need a fast way duplicate a DA开发者_JAVA百科TETIME column in a table and give it a new name. I have a column named myDate in my table called myResults, I need a query to make a new column in the t