The world's most popular open source database

# -------------------------------------------------------------- # sample for xtab.pl # creates a cross-tabulation having locations as rows # and gender items as columns # -------------------------------------------------------------- # usage: perl xtab.pl < location-gender-count.xtab [| mysql -t ] # -------------------------------------------------------------- title=location-gender database=xcompany row_name=location row_alias=town col_name=gender col_alias=gender col_value=1 col_from=FROM employees col_where= col_order= row_from=FROM locations INNER JOIN employees USING(loc_code) row_where= row_order=ORDER BY loc_sort_order row_group=group by location