MySQL Get row with greatest parent row
If you have a database of CDs, and artists, etc. Say you want to get a list of artists with…
Using MAX and DATE_FORMAT to get the latest date from a MySQL table
Don’t use DATE_FORMAT when trying to assertain the latest date in a table. It won’t work. DATE_FORMAT will convert the…