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.

Hello all! I have a MySQL query that is giving me the results that I want, but I'm having difficulty displaying the results in PHP. Here is my SQL statement: SELECT `tkid`,COUNT(*) FROM `xd2e ...

Click the database you want to use to insert data. Type the MySQL insert statement that inserts the characters, placing a backslash in front of any commas or quotes. The following code is an ...

The whole MySQL database creation script runs out of steam before it even starts. The main issue at hand in this scenario is an old dialect class that’s incompatible with the MySQL installation. A ...