by Ember Crooks | Jan 31, 2023 | Featured, mysql, sql
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
by Ember Crooks | Jan 26, 2023 | Featured, mysql, 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...
by Craig S. Mullins | Jan 23, 2023 | escape, sql, string
Every now and then I write about some things that may seem to be basic to old-timers, but can be very confusing to developers the first time they encounter them. Today's post is an example.How do you handle a text string with a single quote in it? For example,...
by Ember Crooks | Dec 6, 2022 | DB2, Db2vsMySQL, Featured, mysql, sql
Every RDBMS has areas where the differences from other RDBMSes are noticeable, and this is one of them between Db2 and MySQL. Most RDBMSes have quirks to the way SQL is written, and this is certainly true of Db2 where some things were there before the SQL-92 standard...
by Craig S. Mullins | Nov 21, 2022 | DBA, education, sql, training
Ensuring access to proper Db2 educational materials should be one of the first issues to be addressed after your organization decides to implement Db2. But education sometimes falls through the cracks... Does your organization understand what Db2 is? How it...
by Ember Crooks | Nov 8, 2022 | DB2, Db2vsMySQL, Explains, Featured, mysql, sql
The goal of this article is to to take one query and use the explain facilities of Db2 to walk through it, and then do the same with MySQL, and then show some of the optimizations I might make for the query and why.… Read the rest
Recent Comments