The world's most popular open source database

# -------------------------------------------------------------- # sample for xtab.pl # creates a cross-tabulation (sum of salary) # having countries as rows and department items as columns # -------------------------------------------------------------- # usage: perl xtab.pl < dept-salary-sum.xtab [| mysql -t ] # -------------------------------------------------------------- title=country-dept-salary database=xcompany row_name=country row_alias=country col_name=dept_code col_alias=dept col_value=salary col_from=FROM departments col_where= col_order=ORDER BY dept_sort_order row_from=FROM countries INNER JOIN locations USING (country_code) INNER JOIN employees USING(loc_code) row_where= row_order=ORDER BY country_sort_order row_group=group by country