Hello,
I have a db that a script failed to run against, and becasue of that a column did not
get updated.
I have a varchar col that has unixtime timstamp in it.
That column gets converted to be readable.
My problem is I have many rows that need to be updated, but
I dont want to re-convert the times that have already been converted.
I know from about 615000000 and up that the records are partially updated.
mysql> select start from table where ID = 615000000;
+---------------------+
| start |
+---------------------+
| 2003-12-28 00:45:16 |
+---------------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT start,ID FROM table ORDER BY id DESC LIMIT 1;
+------------+-----------+
| start | ID |
+------------+-----------+
| 1072603517 | 617168732 |
+------------+-----------+
1 row in set (0.01 sec)
mysql>
So now I want to run my update statment, how do I not update the times that have been
converted??? Help....
my current update statement:
from script:
OID="`echo "select ID from $TBLE order by ID desc limit 1;" | $MSQL -u$UI -p$PD -h$HT
$DB|grep -v ID`"
echo "update $TBLE set start = from_unixtime(start) where ID > '$OID';"| $MSQL -u$UI
-p$PD -h$HT $DB
Thanks for your help up front....
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
