by Ember Crooks | May 30, 2023 | DB2, Db2vsMySQL, Featured, mysql
With a year of fairly extensive MySQL experience under my belt, and uncertainty as to which exciting direction my career will take me next, I wanted to take a moment to write about some of the differences between Db2 and MySQL at a fairly high level.… Read the...
by Ember Crooks | Apr 11, 2023 | DB2, Db2vsMySQL, Featured, mysql
I’m going to walk through the basic creation of auto-incrementing integer columns in MySQL and Db2 and point out some differences and similarities. Functionality Every relational database I have worked with has had a functionality for generating column values....
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 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
by Ember Crooks | Nov 3, 2022 | DB2, Db2vsMySQL, Explains, Featured, mysql
I’ve been spending some time working with indexes as I learn MySQL, and there were a few things I thought were were worth mentioning. As always, I’m writing from my own knowledge with deep experience in IBM DB2, and as a learner when it comes to...
by Ember Crooks | Oct 27, 2022 | DB2, Db2vsMySQL, Featured, mysql
I’ve spent some time understanding how MySQL structures tables and indexes, and wanted to share what I’ve learned. This is not the structure as created in the CREATE TABLE or CREATE INDEX statements, but how that data is generally structured on disk, both...
Recent Comments