Category Archives: MySQL

MySQL Difference Between Dates In Days, Hours, Minutes

Posted on April 1, 2016 by robert

I was researching how to make a JavaScript countdown timer for a personal webpage, because that’s the only way to go if you want interactivity (client-side scripting at its best), and I thought, ‘how can I do this in MySQL?’ … Continue reading →

Posted in MySQL | Tagged , , , | Leave a comment

Arrival At Pluto

Posted on June 13, 2015 by robert

New Horizons is scheduled to arrive at the PLANET Pluto (don’t give me any of that dwarf or minor crap) on: select DATE_ADD(date(‘2015-06-02’), INTERVAL 42 DAY) as ‘Arrival at Pluto’; Kind of sad that I thought it would be easier … Continue reading →

Posted in MySQL | Tagged , , , , , | Leave a comment

Install A Linux Web Server On Your Windows 7 PC With Vagrant

Posted on February 2, 2015 by robert

First, I’d like to reference an excellent video tutorial that I used for my initial foray into the Vagrant world. Click here to see that tutorial. Disclaimer: This blog entry does not necessarily follow safe computer/networking procedures. Use this only … Continue reading →

Posted in Computer Stuff, MySQL, PHP | Tagged , , , , , , | Leave a comment

MySQL Query Using Derived Temp Table And Left Join Against Self

Posted on January 8, 2015 by robert

An example (for a personal project) where I’m using a derived temp table (designated ‘x’) and a table joined against itself, used to find the max timestamp. Thanks, Martin! select tt.*, fkid, max(fldTimeStamp) as `maxTimeStamp`, (count(*)-1) as `calcCount` from tbl_todo … Continue reading →

Posted in MySQL | Tagged , , | Leave a comment

Syncing MySQL Database Between A Mac And PC

Posted on April 13, 2014 by robert

I’ve been a long time Mac hater. Recently, though, I broke down and bought a Mac laptop. Being a geek on many levels, I immediately had to set it up as a development server environment. I won’t go into the … Continue reading →

Posted in Computer Stuff, Mac, MySQL | Tagged , , , | Leave a comment