MAIL PROTECTED]
Sent: Saturday, November 08, 2003 7:26 AM
To: [EMAIL PROTECTED]
Subject: Update table with UNIX_TIMESTAMP
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
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 issu