mysql> create table t_1 (obj_type varchar( 10 ), obj_count int,day_of_week char( 3 ));
Query OK,  0  rows affected ( 0 . 13  sec)

mysql> insert into t_1 values ('table', 20 ,'FRI'), ('table', 14 ,'SAT'),('chair', 1 ,'FRI'),('chair', 67 ,'MON'),('book', 7 ,'FRI');
Query OK,  5  rows affected ( 0 . 03  sec)
Records:  5   Duplicates:  0   Warnings:  0 

mysql> select * from t_1;
+----------+-----------+-------------+
| obj_type | obj_count | day_of_week |
+----------+-----------+-------------+
| table    |         20  | FRI         |
| table    |         14  | SAT         |
| chair    |          1  | FRI         |
| chair    |         67  | MON         |
| book     |          7  | FRI         |
+----------+-----------+-------------+
 5  rows in set ( 0 . 00  sec)

mysql> select distinct obj_type into @type1 from t_1 limit  0 , 1 ;
Query OK,  1  row affected ( 0 . 05  sec)

mysql> select distinct obj_type into @type2 from t_1 limit  1 , 1 ;
Query OK,  1  row affected ( 0 . 00  sec)

mysql> select distinct obj_type into @type3 from t_1 limit  2 , 1 ;
Query OK,  1  row affected ( 0 . 00  sec)

mysql> select distinct obj_type into @type4 from t_1 limit  3 , 1 ;
Query OK,  0  rows affected,  1  warning ( 0 . 00  sec)

mysql> select distinct obj_type into @type5 from t_1 limit  4 , 1 ;
Query OK,  0  rows affected,  1  warning ( 0 . 00  sec)

mysql>
mysql> select @type1,@type2,@type3,@type4,@type5;
+--------+--------+--------+--------+--------+
| @type1 | @type2 | @type3 | @type4 | @type5 |
+--------+--------+--------+--------+--------+
| table  | chair  | book   | NULL   | NULL   |
+--------+--------+--------+--------+--------+
 1  row in set ( 0 . 00  sec)


mysql> select obj_type,
    -> IF(obj_type=@type1,obj_count, 0 ) as t_1,
    -> IF(obj_type=@type2,obj_count, 0 ) as t_2,
    -> IF(obj_type=@type3,obj_count, 0 ) as t_3,
    -> IF(obj_type=@type4,obj_count, 0 ) as t_4,
    -> IF(obj_type=@type5,obj_count, 0 ) as t_5,
    -> day_of_week
    -> from t_1;
+----------+------+------+------+------+------+-------------+
| obj_type | t_1  | t_2  | t_3  | t_4  | t_5  | day_of_week |
+----------+------+------+------+------+------+-------------+
| table    |    20  |     0  |     0  |     0  |     0  | FRI         |
| table    |    14  |     0  |     0  |     0  |     0  | SAT         |
| chair    |     0  |     1  |     0  |     0  |     0  | FRI         |
| chair    |     0  |    67  |     0  |     0  |     0  | MON         |
| book     |     0  |     0  |     7  |     0  |     0  | FRI         |
+----------+------+------+------+------+------+-------------+
 5  rows in set ( 0 . 00  sec)