Ubiq BI

How to Round Timestamp in MySQL

Sometimes you need to round timestamp to hour, minute, day, seconds, month. Here is how to round timestamp in MySQL

Sometimes you may need to change values of multiple columns in PostgreSQL. Here is how to update multiple columns in PostgreSQL

Sometimes you may need to change a table name in MySQL. Here is how to rename table in MySQL.

PostgreSQL allows you to compare arrays using operators. Here is how to compare arrays in PostgreSQL.

Sometimes you may need to run multiple MySQL server on single machine. Here is how to run multiple MySQL instances on same machine.

Sometimes you may need to change user password in PostgreSQL. Here are the steps to change user password in PostgreSQL.

You need to create superuser for database administration. Here is how to create user with superuser privileges in PostgreSQL.

Sometimes you may need to insert multiple rows in MySQL. Here is how to insert multiple rows in MySQL.

Sometimes you may need to copy data from one table to another using SQL. Here is how to copy data from one table to another in SQL.