mysql数据库取奇数行数据

SELECT * FROM table_name LIMIT 1, 2;

SET @row_number:=0;
SELECT * FROM (
    SELECT (@row_number:=@row_number + 1) AS row_num, table_name.* 
    FROM table_name
) AS temp
WHERE row_num % 2 <> 0;

SELECT t1.* FROM table_name t1
JOIN (
    SELECT t2.id 
    FROM table_name t2
    LEFT JOIN table_name t3 ON t3.id < t2.id
    WHERE t3.id IS NULL
) AS temp ON t1.id = temp.id;

SELECT * FROM (
    SELECT *, ROW_NUMBER() OVER () AS row_num
    FROM table_name
) AS temp
WHERE MOD(row_num, 2) <> 0;