Indexing varchar columns

[altendew]

Well heres the current situation.. I have 100,858 rows, and I have one row called ip that stores IP adsresses.

ip varchar(255)

Now I indexed ip, and it results to this.

ip INDEX 100858

I don't understand how the index number is the same as the row number when there's multiples of the same ip in different rows :-?

 

[nego78]

try read this

http://dev.mysql.com/doc/mysql/en/mysql-indexes.html

and you'll understand that index is a modified 'copy' of table where indexed column is sorted

gry online