mysql 取奇数偶数行

 余数等于1则为真，打印奇数； 余数等于0则为真，打印偶数

mysql> select * from brand;
+----------+------------+
| brand_id | brand_name |
+----------+------------+
|        1 | 诺基亚     |
|        2 | 摩托罗拉   |
|        3 | 多普达     |
|        4 | 飞利浦     |
|        5 | 夏新       |
|        6 | 三星       |
|        7 | 索爱       |
|        8 | LG         |
|        9 | 联想       |
|       10 | 金立       |
|       11 | 恒基伟业   |
+----------+------------+
11 rows in set (0.03 sec)

mysql> select * from brand,(select @a:=0) tmp where (@a:=@a+1)%2=1;
+----------+------------+-------+
| brand_id | brand_name | @a:=0 |
+----------+------------+-------+
|        1 | 诺基亚     |     0 |
|        3 | 多普达     |     0 |
|        5 | 夏新       |     0 |
|        7 | 索爱       |     0 |
|        9 | 联想       |     0 |
|       11 | 恒基伟业   |     0 |
+----------+------------+-------