56,675
社区成员
发帖
与我相关
我的任务
分享
mysql> select * from t_xluzhong;
+-------+------------+-------+-----------+
| d_one | d_time_one | d_two | d_timetwo |
+-------+------------+-------+-----------+
| 1 | 2009-02-01 | 0 | NULL |
| 2 | 2009-02-02 | 1 | NULL |
| 3 | 2009-02-02 | 1 | NULL |
| 4 | 2009-02-05 | 1 | NULL |
| 5 | NULL | 2,3,4 | NULL |
+-------+------------+-------+-----------+
5 rows in set (0.00 sec)
mysql>
mysql> update t_xluzhong t ,(
-> select a.d_one,(select d_time_one from t_xluzhong where d_one =(select max(d_one) from t_xluzhong where FIND_IN_SET(d_one,a.d_two))) as k
-> from t_xluzhong a) f
-> set t.d_timetwo=f.k
-> where t.d_one=f.d_one;
Query OK, 4 rows affected (0.09 sec)
Rows matched: 5 Changed: 4 Warnings: 0
mysql> select * from t_xluzhong;
+-------+------------+-------+------------+
| d_one | d_time_one | d_two | d_timetwo |
+-------+------------+-------+------------+
| 1 | 2009-02-01 | 0 | NULL |
| 2 | 2009-02-02 | 1 | 2009-02-01 |
| 3 | 2009-02-02 | 1 | 2009-02-01 |
| 4 | 2009-02-05 | 1 | 2009-02-01 |
| 5 | NULL | 2,3,4 | 2009-02-05 |
+-------+------------+-------+------------+
5 rows in set (0.00 sec)
mysql>