Skip to content

Instantly share code, notes, and snippets.

@ian29
Created January 18, 2012 23:06
Show Gist options
  • Save ian29/1636387 to your computer and use it in GitHub Desktop.
Save ian29/1636387 to your computer and use it in GitHub Desktop.
update clean_sch set all_read04_0910 = 'n/a' where all_read04_0910 = '0.0%';
update clean_sch set all_read08_0910 = 'n/a' where all_read08_0910 = '0.0%';
update clean_sch set all_read10_0910 = 'n/a' where all_read10_0910 = '0.0%';
update clean_sch set all_read12_0910 = 'n/a' where all_read12_0910 = '0.0%';
update clean_sch set all_read04_0809 = 'n/a' where all_read04_0809 = '0.0%';
update clean_sch set all_read08_0809 = 'n/a' where all_read08_0809 = '0.0%';
update clean_sch set all_read10_0809 = 'n/a' where all_read10_0809 = '0.0%';
update clean_sch set all_read12_0809 = 'n/a' where all_read12_0809 = '0.0%';
update clean_sch set all_read04_0708 = 'n/a' where all_read04_0708 = '0.0%';
update clean_sch set all_read08_0708 = 'n/a' where all_read08_0708 = '0.0%';
update clean_sch set all_read10_0708 = 'n/a' where all_read10_0708 = '0.0%';
update clean_sch set all_read12_0708 = 'n/a' where all_read12_0708 = '0.0%';
update clean_sch set all_math04_0910 = 'n/a' where all_math04_0910 = '0.0%';
update clean_sch set all_math08_0910 = 'n/a' where all_math08_0910 = '0.0%';
update clean_sch set all_math10_0910 = 'n/a' where all_math10_0910 = '0.0%';
update clean_sch set all_math12_0910 = 'n/a' where all_math12_0910 = '0.0%';
update clean_sch set all_math04_0809 = 'n/a' where all_math04_0809 = '0.0%';
update clean_sch set all_math08_0809 = 'n/a' where all_math08_0809 = '0.0%';
update clean_sch set all_math10_0809 = 'n/a' where all_math10_0809 = '0.0%';
update clean_sch set all_math12_0809 = 'n/a' where all_math12_0809 = '0.0%';
update clean_sch set all_math04_0708 = 'n/a' where all_math04_0708 = '0.0%';
update clean_sch set all_math08_0708 = 'n/a' where all_math08_0708 = '0.0%';
update clean_sch set all_math10_0708 = 'n/a' where all_math10_0708 = '0.0%';
update clean_sch set all_math12_0708 = 'n/a' where all_math12_0708 = '0.0%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment