I don't think it'll work. On Oracle, there is an UNPIVOT function that I think would help you here. Unfortunately, I'm not sure if mySQL has an equivalent function, so this may be useless to you.

The MySQL syntax offers several ways to avoid repeating names in a table and to order names alphabetically. You cannot use the MySQL keyword "auto_increment" on a character-type column ...