0

More than 5 years have passed since last update.

@kazup0n(Kazuhiro Sasaki)

MySQLでn行ずつ結果を取得する

MySQL

Last updated at 2016-07-19Posted at 2016-07-19

概要

ユーザー変数を使って行番号を付ける
行番号の剰余でフィルタリング

例

n=3の場合

SELECT
*
FROM (
  SELECT 
    @i:=@i+1  as rownum, 
    TABLE_NAME.* 
  FROM 
    (select @i:=0) as dummy,
    TABLE_NAME) tmp 
   )
WHERE 
  tmp.rownum % 3 = 1

0

Register as a new user and use Qiita more conveniently

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up

0