mysql update value from another column in the same table

Question

I have a table with these 2 columns : date and day date has dates and day is empty I would like to do something like this :

UPDATE table SET day='day(date)'

the idea is to take the date (its in date time format) and take out the day and insert it into the day column. any ideas ?

Can you given an example? I am confused by day date description. — Li Kia Chiu, Oct 13 '14 at 23:57

score 1 · Accepted Answer · answered Oct 13 '14 at 23:57

1

Hope this will help

UPDATE table SET day = EXTRACT(DAY FROM date)

answered Oct 13 '14 at 23:57

1 Answers1