MySQL – Pivot table per day

Consider the following schema: CREATE TABLE IF NOT EXISTS `tblappointment` ( `app_id` int(6), `app_date` date, `app_price` int(6), `app_price_in` int(6), `app_price_out` int(6), PRIMARY …