Description:
see how to repeat
How to repeat:
mysql> create table tt(C_FIRST varchar(64) NOT NULL, C_VCHAR varchar(9000) DEFAULT NULL , C_DATA text);
Query OK, 0 rows affected (0.06 sec)
mysql> insert into tt values("aaa","bbb","ccc");
Query OK, 1 row affected (0.00 sec)
mysql> insert into tt values("aaa","bbb","ccc");
Query OK, 1 row affected (0.00 sec)
mysql> insert into tt values("aaa","bbb","ccc");
Query OK, 1 row affected (0.00 sec)
mysql> insert into tt values("aaa","bbbbbb","ccc");
Query OK, 1 row affected (0.00 sec)
mysql> insert into tt values("aaa","bbbbbb","ccc");
Query OK, 1 row affected (0.00 sec)
mysql> insert into tt values("aaa","bbbbbb","ccc");
Query OK, 1 row affected (0.00 sec)
mysql> select distinct c_first,c_data,length(c_vchar),count(*) from tt group by c_first,c_data,length(c_vchar);
+---------+--------+-----------------+----------+
| c_first | c_data | length(c_vchar) | count(*) |
+---------+--------+-----------------+----------+
| aaa | ccc | 3 | 3 |
| aaa | ccc | 6 | 3 |
+---------+--------+-----------------+----------+
2 rows in set (0.00 sec)
mysql> select distinct c_first,c_data,length(c_vchar),count(*) from tt group by c_first,c_data,length(c_vchar) order by 1,2,3;
+---------+--------+-----------------+----------+
| c_first | c_data | length(c_vchar) | count(*) |
+---------+--------+-----------------+----------+
| aaa | ccc | 3 | 3 |
+---------+--------+-----------------+----------+
1 row in set (0.00 sec)