One master ID table in MySQL

[vooood]

Hi!

I'm not sure if this is possible directly in MySQL but I had to ask. I want to have one table in MySQL that will hold the ID's, names, and descriptions of items. Then I wish other tables (each table is for one type of an item) that will not have names and descriptions in them but only an ID that is directly linked to the ID in the "master ID" table.

I need this like this because there will be a lot of searches and indexing in the item tables and I wish the names (or at least description blob/text) to be outside for faster searching (and easier multi-language support later).

Thank you in advance..

[Marco van Herwaarden]

Sure if you have enough knowledge of MySQL and PHP you can create such functions.

[vooood]

I know I can create it with PHP, but is there a way to do it using only MySQL?

[Farcaster]

If you want to do this entirely with MySQL and not make changes to the datamanagers or utilize plugins, it is possible. You could use MySQL triggers to insert a duplicated row with whatever information you want into this secondary table. Triggers became available in version MySQL v5.0.2. You can read more about them here: http://dev.mysql.com/doc/refman/5.0/en/triggers.html