Ryadel

MySQL Master-Master Replication setup in 5 easy steps

MySQL – Convert all Tables of one or more Database(s) from MyISAM to InnoDB and vice-versa

October 17, 2015January 28, 2018 - by Ryan - 8 Comments.

Have you ever needed to convert one, some or all the tables of a MySQL Database from MyISAM to InnoDB or the other way around? Here’s a couple queries you …

Coding / SQL

MySQL: two-columns Primary Key with auto-increment

July 25, 2015October 29, 2017 - by Ryan - Leave a Comment

Everyone working with MySQL (and DBMS in general) knows about the AUTO_INCREMENT attribute that can be used on a column – often the primary key – to generate a unique identity for new …