Skip to main content
snippets
S
nippets
Latest Snippets
Backup database shell script
Shell
13 years ago
backup
cron
database
mysql
shell
Monitor logs in real time with SSH
Shell
13 years ago
log
shell
ssh
tail
Bulk Minify YUI shell script
Shell
13 years ago
minify
shell
MySQL clone database
Shell
13 years ago
database
mysql
htaccess display Markdown if exists
Apache
13 years ago
apache
htaccess
markdown
Backup database and copy to remote
Shell
13 years ago
backup
bash
database
mysql
shell
Backup account and database
Shell
13 years ago
backup
database
shell
Completely remove files from git history
Shell
13 years ago
git
Generate a random binary file
Shell
13 years ago
file
shell
Replace text in all string columns of a database
SQL
13 years ago
mysql
replace
text
Monthly sales in MySQL
SQL
13 years ago
mysql
pivot
query
report
Great circle distance in MySQL
SQL
13 years ago
circle
distance
formula
mysql
Percentiles in MySQL
SQL
13 years ago
algorithm
mysql
percentile
statistics
Winning Streaks in MySQL
SQL
13 years ago
algorithm
mysql
query
Gaps in a time series in MySQL
SQL
13 years ago
analysis
datetime
mysql
query
Aggregates excluding leaders in MySQL
SQL
13 years ago
aggregate
mysql
rank
All X for which all Y are Z MySQL query
SQL
13 years ago
aggregate
mysql
query
Aggregates of specified size
SQL
13 years ago
aggregate
group
mysql
query
Avoiding repeat aggregation in MySQL
SQL
13 years ago
aggregate
mysql
query
Combine Group_Concat() with counts in MySQL
SQL
13 years ago
group
mysql
query
First
«
120
121
122
123
124
125
126
127
128
129
130
»
Last
More »