jbanana: Badly drawn banana (Default)
[personal profile] jbanana
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...

May 2025

M T W T F S S
   1234
5678 91011
12131415161718
19202122232425
262728293031 

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 17th, 2025 08:02 pm
Powered by Dreamwidth Studios