The PIVOT table type is very useful to sort and sum the columns in a table. It's similar to GROUP BY but with a more understandable layout. This sort of task is often used to sort and sum columns of data in a desktop spreadsheet program.
Launch the
mysqlcommand-line client application and connect to thetestdatabase on our MariaDB server. If thetestdatabase does not exist, create it first.Run the following
CREATE TABLEstatement to create anexpensestable:CREATE TABLE expenses ( who varchar(64), day varchar(10), what varchar(64), amount varchar(10) );
Add some data to the table by executing the following command lines:
INSERT expenses VALUES ("Daniel","2013-09-01","Clothing",42.50), ("Amy","2013-09-02","Food",5.22), ("Daniel","2013-09-01","Clothing",27.75), ("Daniel","2013-09-03","Food",10.27), ("Amy","2013-09-03","Gas",42.84), ("Amy","2013-09-01","Food",15.01), ("Amy","2013-09-01","Clothing",11.00), ("Daniel...