Advanced Search

ktrout

Member since 11/03/2013

12 snippets

3616 profile views

0 Comment(s) Posted

View their favorites

their Tags

Profile

Achievement

first submission:submitting first snipplet

ktrout's Recent Snippets

« Prev 1 Next »
pivot data. input source query in the form : +--------+-----------+-------------+-------------+ | name | pivot_fid | pivot_fname | pivot_value | +--------+-----------+-------------+-------------+ | apple | 1 | is red...
0 2218 posted 9 years ago by ktrout
procedure to throw application defined error
0 2250 posted 9 years ago by ktrout
calculate rank ( with ties ) over points table
0 2278 posted 9 years ago by ktrout
clone table with structure and indexes
0 2494 posted 9 years ago by ktrout
unroll variable length string list to normalised form.
0 2232 posted 9 years ago by ktrout
search for tables in mysql catalog ( information_schema )
0 1250 posted 9 years ago by ktrout
stored procedure for executing batch sql statements
0 2225 posted 9 years ago by ktrout
creates a minimal calendar table
0 2427 posted 9 years ago by ktrout
one cross join for each ai in definition of decimal number as sum(ai*10^i)
0 2179 posted 9 years ago by ktrout
Source creating a new database (and inserting some records)
0 3508 posted 11 years ago by ktrout
simple ftp download example
0 2263 posted 11 years ago by ktrout
Used parts of this in resetting my torrent upload information after losing if (was experimenting with switching to a new torrent-client). Only works on transmission-gtk torrent files [i think]
0 1282 posted 11 years ago by ktrout
« Prev 1 Next »