Using query to change table mapping
Posted
by crapbag
on Stack Overflow
See other posts from Stack Overflow
or by crapbag
Published on 2010-05-07T06:49:14Z
Indexed on
2010/05/07
7:18 UTC
Read the original article
Hit count: 101
mysql
I have a table mytable( id, key, value). I realize that key is generating a lot of data redundancy since my key is a string. (my keys are really long, but repetititve) How do I build a separate table out that has (key, keyID) and then alternate my table to be mytable( id, keyID, value) and keyTable(keyID, key) ?
© Stack Overflow or respective owner