The following is a cheat sheet of basic syntax used to set up, and manipulate databases using Mysql. This cheat sheet assumes that you already have mysql installed and initialized on your VM. First, ...

I need to search about twenty columns for given a string with wildcards. The query essentially looks like this: SELECT * FROM `the_table` WHERE ...

Yeah, but having the INSERT statement be able to use the UPDATE syntax is pretty cool. I'm not a fan of dealing with the column name list and value/parameter list being separate. More options ...

load database from mysql://user:password@localhost/db into postgresql:///db WITH include drop, create tables, no truncate, create indexes, reset sequences, foreign keys SET maintenance_work_mem to ...