Ad6CUTqG

1contador , nClase
2	
3SELECT a.*, (@rownum:=@rownum+1) contador
4FROM  (SELECT @rownum:=0) t, `mi_tabla` a;
5	
6CREATE TABLE IF NOT EXISTS `mi_tabla` (
7  `id` int(6) unsigned NOT NULL,
8  `rev` int(3) unsigned NOT NULL,
9  `content` varchar(200) NOT NULL,
10  PRIMARY KEY (`id`)
11) DEFAULT CHARSET=utf8;
12
13INSERT INTO `mi_tabla` (`id`, `rev`, `content`) VALUES
14  ('1', '1', 'text 1'),
15  ('2', '1', 'text 2'),
16  ('6', '2', 'text 3'),
17  ('9', '3', 'text 4');
18
19SELECT a.*, (@rownum:=@rownum+1) contador
20FROM  (SELECT @rownum:=0) t, `mi_tabla` a
21ORDER BY a.id;
22	
23| id | rev | content | contador |
24|----|-----|---------|----------|
25|  1 |   1 |  text 1 |        1 |
26|  2 |   1 |  text 2 |        2 |
27|  6 |   2 |  text 3 |        3 |
28|  9 |   3 |  text 4 |        4 |