I have an old table that has about 2000 records and hasn't been modified. I realized it was missing a create_date. Do anyone know or have any slick SQL code to extract out the date from the timestamp field and update and insert the date into the create_date field?

Thanks!
--
<--------------------------------------------------------------->
    Alex Pilson
    FlagShip Interactive, Inc.
    [EMAIL PROTECTED]
    404.642.8225 CELL
<--------------------------------------------------------------->

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to