阅读背景:

自动从表中选择随机行

来源:互联网 

I'm working on a project that requires back-end service. I am using MySQL and php scripts to achieve communication with server side. I would like to add a new feature on the back-end and that is the ability to generate automatically a table with 3 'lucky' members from a table_members every day. In other words, I would like MySQL to pick 3 random rows from a table and add these rows to another table (if is possible). I understand that, I can achieve this if manually call RAND() function on that table but ... will be painful!I'm working on a project that requires back-end




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: