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

Sometimes we need to check the CREATE TABLE syntax for already created table in the database. When we need to check what kind of columns and what datatype a column has in a table then we require the ...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near <Keyword> It occurs because of ...

Sequences in MySQL help ensure that values aren't repeated, and many applications require database tables to have an incrementing "id" column. The MySQL syntax offers several ways to avoid repeating ...

SELECT * FROM `the_table` WHERE `field1` LIKE 'string%' OR `field2` LIKE 'string%' OR `field3` LIKE 'string%' OR `field4` LIKE 'string%' OR `field5` LIKE 'string%' OR `field6` LIKE 'string%' OR ...

$ sudo -u postgres pgloader commands 2014-08-29T19:29:17.069000Z LOG Starting pgloader, log system is ready. 2014-08-29T19:29:17.111000Z LOG Main logs in '/tmp ...

For developers familiar with MySQL, you've probably heard that MariaDB is the next generation of the database engine. MySQL has long been the traditional database in Linux, Apache, MySQL, and PHP ...