Re: Mysql updating dates in a table

> On Tue, 2009-08-04 at 16:21 -0700, JD Austin wrote:
> > http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
> > You can use Str_to_date to convert it to a date.
> > Date/timestamp data should be one of the date types (Datetime, date,
> > timestamp).
> > I'd do it like this (all sql and won't lose data):
> >      1. Add a column to the table that is date/datetime/timestamp (in
> >         your case date looks right)
> >      2. update the new column using the str_to_date function
> >      3. Check for rows that have nulls in that column - fix them
> >      4. set the existing column value to NULL
> >      5. change the column to a date using alter table.
> >      6. update the column to be whatever you called the new column you
> >         added.
> >      7. Drop the new column that you added.
> >      8. add not null constraint to your original date column
> ----
> Yes, I am on dev.mysql.com... (v5.0 is correct too)