Painful geekery
Nov. 19th, 2013 05:29 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
By combining Cygwin and some "new"
And I say "new" in quotes because it changed at some time since I learned the "old" syntax twenty-something years ago...
for
syntax, I can find tables inserted into by a huge script and generate queries to see how many rows there are now: C:\sql> for /f %G in ('grep "insert into" load.sql ^| cut -d " " -f 3 ^| sort ^| uniq') do @echo select count(*) from %G;If only the load script worked then there would have been some point to figuring that out.
And I say "new" in quotes because it changed at some time since I learned the "old" syntax twenty-something years ago...