mysql> select a.cur_id,b.cur_id from cur as a, cur as b limit 5 -> ; +--------+--------+ | cur_id | cur_id | +--------+--------+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 1 | | 5 | 1 | +--------+--------+ 5 rows in set (0.02 sec)