UPDATE `表名` SET `字段名`=ceiling(rand()*500000+500000) WHERE (條件);
寫入11位手機
UPDATE xm_user a SET a.user_mobile = CONCAT('15810',ceiling(rand()*500000+500000) );
如何聯系我:【萬裡虎】www.bravetiger.cn
【QQ】3396726884 (咨詢問題100元起,幫助解決問題500元起)
【部落格】http://www.cnblogs.com/kenshinobiy/