SELECT * From tableName1 WHERE MOD(id,10)=0; 
// id divided by 10 wITh a remainder equal to 0 (exact)

或没有顺序列id

SELECT * From ( 
    SELECT 
        @row := @row +1 AS rowNum,colName1 
    FROM ( 
        SELECT @row :=0) r,tableName1
    ) ranked 
WHERE rowNum % 10 = 1