col1 col2
abc  1
abc  2
ab   1
ab   2
ab   3
abcd 1

CREATE TABLE abc (name1 VARCHAR(255),name2 INT AUTO_INCREMENT, KEY (name1,name2));
INSERT INTO abc (name1) VALUES ('abc');
INSERT INTO abc (name1) VALUES ('abc');
INSERT INTO abc (name1) VALUES ('abcd');
INSERT INTO abc (name1) VALUES ('abcd');
INSERT INTO abc (name1) VALUES ('abc');
SELECT * FROM abc;
+-------+-------+
| name1 | name2 |
+-------+-------+
| abc   |     1 |
| abc   |     2 |
| abc   |     3 |
| abcd  |     1 |
| abcd  |     2 |
+-------+-------+