MySQL’s “partial” Group By

This is one area that was not a surprise to me coming from Db2 to MySQL, as I’ve had to deal with people confused in the other direction for years. Essentially, MySQL allows a syntax for GROUP BY that Db2 and most RDBMSes do not allow.… Read the rest

Using ChatGPT to Write SQL

Working in technology, I’ve heard a number of things about ChatGPT from various news sources. I was particularly interested hearing some teachers saying it was the end of being able to properly detect students cheating when writing papers. Then I heard a teacher...