I have created my database and all of the rows. The first row i created as the id with a primary index.
After that i wrote out the rest and selected index as the index. I think this is what has thrown up the error
#1070 - Too many key parts specified; max 16 parts allowed
However i am unsure what else to set them as i mean i have primary, unique, index and fulltext. The information being stored is for a combat system and it has the likes of health, energy, money, level, rank etc and honestly i am slightly confused.
Can anyone shed some light on what i should be indexing these as because i could pick unique but then i read that it apparently means unique to that row so would that be an issue if say fire and water where the same value?.
Sorry if this sounds noobish, i am still learning