Skip to content

Instantly share code, notes, and snippets.

onlinelei

Block or report user

Report or block onlinelei

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View mysql_sql.sql
-- mysql单条SQL查询出分页和总数
SELECT SQL_CALC_FOUND_ROWS t.* FROM ( SELECT 1 AS allCount,
dr.id AS reportId
FROM dr_daily dr
WHERE 1=1
GROUP BY dr.id
ORDER BY dr.create_time DESC
)t
LIMIT 1,2
You can’t perform that action at this time.