MySQL – Rows to Columns

I tried to search posts, but I only found solutions for SQL Server/Access. I need a solution in MySQL (5.X). I have a table (called history) with 3 columns: hostid, itemname, itemvalue. If I do a select (select * from history), it will return +——–+———-+———–+ | hostid | itemname | itemvalue | +——–+———-+———–+ | 1 … Read more