Category: Databases and ORM

How to find my.cnf MySQL configuration file in Linux?

After installing MySQL and in order to provide configuration to it, we usually want to locate the famous my.cnf configuration file; if you are running a GNU/Linux distribution like Ubuntu, then you can use the following command to know where is the absolute path of this file: find / -name my.cnf The output of this […]

Read More

How to get MySQL time zone?

Under certain circumstances it is relevant to know the timezone in which your date is being stored in a Relational Database System, for example MySQL. One of the easiest ways to know is just by running following command: Step 1. Login to MySQL mysql -u root -p Step 2. Run a “select” query to get […]

Read More

Useful IBM DB2 commands

When I start to use a new Database Relational System like IBM DB2, first thing I think is “I need to learn how to do this…”, so, in order to answer that question I have written this small article A useful list of IBM DB2 commands in Base22 Knowledge Wiki where you will find a set of commands that I […]

Read More