摘要: SELECT R.* FROM trans_flow R, (SELECT order_no, MAX(status_time) AS status_time FROM trans_flow GROUP BY order_no) S WHERE R.order_no = S.order_no AN... 阅读全文
posted @ 2014-09-11 17:40 全新时代-小小程序员大梦想 阅读(453) 评论(1) 推荐(0) 编辑
摘要: 1.关联修改#解决思路 UPDATE tb1,tb2 SET tb1.address=tb2.address WHERE tb1.name=tb2.nameUPDATE car c,tmpcolorcode t SET c.color_code=t.color_code WHERE c.reg_n... 阅读全文
posted @ 2014-09-11 10:55 全新时代-小小程序员大梦想 阅读(6694) 评论(5) 推荐(0) 编辑