I have a table in MySQL with the following data.
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard 23498 In Stock bangalore
Keyboard 45646 Allocated bangalore
Mouse 234234 Decommisioned hyderabad
I am looking to execute a MySQL query in my Codeigniter application to provide the below output.
Assettype In Stock Allocated Decommisioned Location
Mouse 1 1 0 chennai
Keyboard 1 1 0 bangalore
Mouse 0 0 1 hyderabad