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, ...

sure there's a better way, use something to validate the sql up front. MySQL is brutal in many, many ways. It will bite you in the ass a dozen different ways.