Sreeram Sreenivasan, Author at Ubiq BI

How To Change MySQL Server Time Zone

Sometimes you may need to change MySQL server time zone to UTC or change timezone in cPanel. Here’s how to change MySQL server time zone.

PostgreSQL create function allows you to create stored procedure and functions in PostgreSQL. Here’s how to use PostgreSQL create function.

PostgreSQL Create Schema allows you to create database schema in PostgreSQL. Here’s how to create schema in PostgreSQL.

Sometimes you may need to show indexes in MySQL. Here’s how to list all indexes using MySQL SHOW INDEX command.

Sometimes you may need to compare databases in MySQL. Here’s how to compare databases in MySQL using command line interface.

Many times you may need to create database in PostgreSQL. Here’s how to create database in PostgreSQL using PostgreSQL CREATE DATABASE command.

Sometimes you may need to create table in PostgreSQL. Here’s how to create table using PostgreSQL Create table query.

Sometimes you may need to edit stored procedure or alter stored procedure in MySQL. Here’s how to alter stored procedure in MySQL.

Histograms help visualize frequency distribution in data analysis and reporting. Here’s how to create histogram in PostgreSQL.