Hello I have a table that gets appended to every night with the LOAD DATA command. The column 'start' is a unix timestamp. So when the LOAD DATA is done I then want to update the Column to be human readable.
I was thinking of the following: UPDATE table SET start = UNIX_TIMESTAMP(start); I issue I'm trying to figure out is I dont want this update command to run on rows that have already been converted. What would someone suggest? thanks Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]