使用mysql.help_topic时,数据最多查询637条。怎么修改数据个数上限?
SELECT
@s := @s + 1 AS indexs,
DATE_FORMAT( DATE_SUB( '2020-10-01', INTERVAL @s DAY ) , '%Y-%m-%d' ) AS visitTime
FROM
mysql.help_topic,
( SELECT @s := - 1 ) t
WHERE
@s < 730
ORDER BY
visitTime ASC