Tag Archives: sql

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

Working With XML/XSLT, JSON, And PHP

Posted on July 7, 2015 by robert

So, this tale, which for your sake I will attempt to make brief, is typical of my experiences in web development. As one of my old bosses used to say (and I’m paraphrasing), “if there’s a hard way to do … Continue reading →

Posted in PHP | 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

Graphing With Flot

Posted on March 3, 2015 by robert

I was working on one of my personal projects, graphing data with PHP, when I ran into a wall. Sure, with PHP, you can get all your data (in the words of some famous poet: database, oh database, how do … Continue reading →

Posted in Computer Stuff, jQuery | 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

Trigger Block Logic Or Why I Learned To Love Outlines

Posted on August 17, 2014 by robert

As a child they tried to teach me many things that I resisted learning. How could this possibly be useful was my first question? That, and the fact that their rigid teaching methods didn’t consider learning a concept enough, caused … Continue reading →

Posted in Computer Stuff, SQL, writing | Tagged , , , , | Leave a comment