fancyPants

fancyPants has asked 1 questions and find answers to 163 problems.

Stats

About

fancyPants questions

Weird behaviour when using read_line in a loop

fancyPants answers

How to get the last month? date +%Y%m -d '1 month ago' doesn't work on March 30
Round timestamp down to nearest minute
Why can't I pipe a password into mysql non-interactively?
MySQL server version for the right syntax to use near '('id')
MySQL lag/lead function?
Generate Unique Long ID for a view in MySql
Combing two queries while using group by
Can you use aggregate values within ON DUPLICATE KEY
mysql - how to get a random time (not date) between two time ranges
renaming a locked table