Nov. 19th, 2013

jbanana: Badly drawn banana (Default)
By combining Cygwin and some "new" 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...

August 2025

M T W T F S S
    123
45678910
11121314151617
1819202122 2324
25262728293031

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags
Page generated Oct. 3rd, 2025 03:13 am
Powered by Dreamwidth Studios