Jake Clarke jaketclarke

Labor, ex-Daniel Andrews, WA and Victorian data director. Co-founder of The Red Fox Group, now at @secnewgate

2 followers · 15 following

SEC Newgate Australia
Melbourne, Victoria, Australia
secnewgate.com.au

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

jaketclarke / census_2016_normalise_table.sql

Last active July 17, 2017 05:10

MySQL stored procedure to tidy up 2016 census tables

	BEGIN
	declare db varchar(100);
	declare dbnew varchar(100);
	declare geog varchar(5);
	declare tbl varchar(100);
	declare tblnew varchar(100);
	declare keycolumn varchar(20);
	declare keytest int;
	declare keytype varchar(20);