Entries from May 2018

How To Select Rows in MySQL with No Matching Entry in Another Table

Author: , May 16th, 2018

SELECT t1.id FROM tableOne t1 LEFT JOIN tableTwo t2 ON t1.id = t2.id WHERE t2.id IS NULL The “WHERE t2.id IS NULL clause” restricts the results to only those rows where the id returned from tableTwo is null. tableTwo.id will be NULL for all records from tableOne where the id is not found in tableTwo.

How To Move Around in Linux CLI Mail

Author: , May 7th, 2018

h Shows you a screenful of message headers (a “header” being the number, sender, date, size and subject). h with no message number shows the current screenful of messages (the number that make up a screenful is set with the screen variable, described below). h$ shows you the last screenful of messages — which is […]

R.I.P. James R. Boyd Sr. (1934 – 2018)

Author: , May 1st, 2018

NORTH RUPERT – James R. Boyd Sr., age 84 passed away peacefully on Monday, April 23, 2018, after an extended hospitalization. Jim was born in Albany, NY, on March 26, 1934, the only child of David and Elizabeth (Adams) Boyd. He grew up in Colonie, NY, and served honorably in the U.S. Army 82nd Airborne […]