MySQL | Vince's Tech Stuff

Association tables

An association table, sometimes known as a cross-reference table, is required when a many-to-many relationship exists between two entities.

This tutorial will explain how you can set up a GeoIP system without relying on external services that usually involve HTTP(). The only drawback to this method is that you will periodically (every few months or so) need to update the IP data to be, well, up-to-date.

Storing player inventory

This is, in part, an extension on my previous tutorial regarding the general table structure and foreign keys. If you haven't read that one, I suggest you do that first.

Technical Information

There are thirteen different weapon slots and thus a player can theoretically hold up to thirteen differ...

Table design and foreign keys

So apparently many people want to use MySQL, but they have no idea on how to properly design a table structure. MySQL is an RDB. Relational Database. With the emphasis on that first word. Make relations! Too many people try to make a large gamemode with one, or maybe two tables. No!