/* Table structure */ DROP table IF EXISTS ' T1 '; CREATE TABLE IF not EXISTS ' T1 ' ( ' id ' INT (1) is not NULL auto_increment, ' name ' VARCHAR (~) Not null, ' Add ' VARCHAR not NULL, PRIMARY KEY (' id ') ) Engine=innodb /* Insert test Data */ INSERT INTO ' t1 ' (' name ', ' Add ') VALUES (' abc ', ' 123 '), (' abc ', ' 123 '), (' abc ', ' 321 '), ( ' abc ', ' 123 '), (' Xzy ', ' 123 '), (' Xzy ', ' 456 '), (' Xzy ', ' 456 '), (' Xzy ', ' 456 '), (' Xzy ', ' 789 '), (' Xzy ', "987"), (' Xzy ', ' 789 '), (' Ijk ', ' 147 '), (' Ijk ', ' 147 '), (' Ijk ', ' 852 '), (' Opq ', ' 852 '), (' Opq ', "963"), (' OPQ ', ' 741 '), (' TPK ', ' 741 '), (' tpk ', ' 963 '), (' tpk ', ' 963 '), (' wer ', ' 546 '), (' Wer ', "546"), (' Once ', ' 546 '); SELECT * from ' T1 '; +----+------+-----+ |ID | name | Add | +----+------+-----+ | 1 | abc | 123 | | 2 | abc | 123 | | 3 | abc | 3 21 | | 4 | abc | 123 | | 5 | xzy | 123 | | 6 | xzy | 456 | | 7 | xzy | 456 | | 8 | xzy | 456 | | 9 | xzy | 789 | | xzy | 987 | | xzy | 789 | | ijk | 147 | | ijk | 147 | | ijk | 852 | | opq | 852 | | opq | 963 | | opq | 741 | | tpk | 741 | | tpk | 963 | | tpk | 963 | | wer | 546 | | wer | 546 | | once | 546 | +----+------+-----+ Rows in Set (0.00 sec) |