How many rows can a MYSQL Table store?

[DarthGuido]

@Noppy

you should have a primary index on a unique id column

Only if a unique id column is needed.

@Noppy

and then other index’s on columns that you are going to be searching on

Yes, it depends on the queries you need to perform. Remember that you can also make composite keys.