Monday, July 30, 2012

Access Join多个表


SELECT c.equip_no, e.equip_nm, c.yc_no, y.yc_nm from (cur_data as c INNER join equip as e on e.equip_no=c.equip_no) INNER join ycp as y on y.equip_no=c.equip_no and y.yc_no=c.yc_no group by c.equip_no, c.yc_no, e.equip_nm, y.yc_nm;

Sunday, July 22, 2012

MySQL随机生成ID

随机生成ID
update www_image set user_id=(select round(round(rand(),4)*30000));