Dump MySQL array result?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: Dump MySQL array result?

Post by VladSun »

A few things:
- you are using varchar column (category_id, game_id) in game_category for referencing an int columns - don't do this :);
- you don't need the surrogate key id in game_category - the game_id and category_id, together, are the natural key for such type of tables;
- you don't have any indexes created on category_id, game_id.
There are 10 types of people in this world, those who understand binary and those who don't
Post Reply