The world's most popular open source database

# ------------------------------------------------------------- # sample for xtab.pl # creates a cross-tabulation having months as rows # and summary of sales by category as columns # ------------------------------------------------------------- # usage: perl xtab.pl < month-category-sales.xtab [| mysql -t ] # ------------------------------------------------------------- title=month-category-sales database=xcompany row_name=DATE_FORMAT(sale_date,"%M %Y") row_alias=month col_name=cat_code col_alias=category col_value=sale_amount col_from=FROM categories col_where= col_order=ORDER BY cat_sort_order row_from=FROM sales row_where= row_order=ORDER BY DATE_FORMAT(sale_date,"%Y%m") row_group=group by month