Loading

update city_demo set city=(select city from city order by rand() limit1);

update city_demo set city=(select city from city order by rand() limit1);

因为使用了rand()函数,所以每一次查询的结果是不一样的,所以会产生随机的数据;

 

posted @ 2018-03-05 13:56  stono  阅读(136)  评论(0编辑  收藏  举报