SQLite随机获取一行数据

  Mysql中随机获取一行数据:

1 SELECT * FROM table ORDER BY RAND() limit 1

  SQLite中随机获取一行数据:

1 SELECT * FROM table ORDER BY RANDOM() limit 1

  limit后面跟你要随机生成多少的数据

原文地址:https://www.cnblogs.com/demo-deng/p/9626131.html