If you give someone a program , you will frustrate them for a day; if you teach them how to program, you will frustrate them for a lifetime.IT 這段話的意思是，如果你交給某人一隻程式，你將折磨他一整天;如果你教會某人如何寫程式，你將折磨他一輩子。

部落格全站分類：數位生活

BloggerAds

Jan 01 Mon 2018 01:11
mysql 分頁sql - gaocong

文章出處

-- pageSize=3 pageIndex total=7
-- 開始行號 startRowNum=(pageIndex-1)*pageSize+1;
-- 結束行號 endRowNum=pageIndex*pageSize
-- 總頁數 (total+pageSize-1)/pageSize



select *  from (
SELECT `code`,cname,@rownum:=@rownum+1 as row_num FROM `dic_town`,(select @rownum:=0) t
)as a where 1=1 and  a.row_num BETWEEN 1 and 3;

select count(*) from `dic_town`;