ubiq

Build dashboards & reports in minutes

  • Features
  • Pricing
  • Blog
  • What is Ubiq
  • Free Trial

How to Run Multiple MySQL Instances on Same Machine

December 2, 2020December 3, 2020 Ubiq MySQL
run multiple mysql instances

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

Continue reading


How To Change User Password in PostgreSQL

December 1, 2020December 1, 2020 Ubiq PostgreSQL
change user password in postgresql

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

Continue reading


How To Create User With Superuser Privileges in PostgreSQL

November 30, 2020November 30, 2020 Ubiq PostgreSQL
how to create user with superuser privileges in postgresql

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

Continue reading


How to Insert Multiple Rows in MySQL

November 27, 2020November 27, 2020 Ubiq MySQL
insert multiple rows in mysql

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

Continue reading


How to List All Users in PostgreSQL

November 26, 2020November 26, 2020 Ubiq PostgreSQL
list all users in postgresql

Sometimes you need to list all users in database. Here is how to list all users in PostgreSQL.

Continue reading


How To Update a Column Based on Another Column in SQL

November 26, 2020November 26, 2020 Ubiq MySQL
update a column based on another column

Here is how to update a column based on another column in SQL Server, MySQL, PostgreSQL.

Continue reading


How to Check PostgreSQL version

November 25, 2020November 25, 2020 Ubiq PostgreSQL
how to check postgresql version

Sometimes you may need to find PostgreSQL version or get PostgreSQL version. Here is how to check PostgreSQL version for your database.

Continue reading


How To Update Multiple Columns in MySQL

November 25, 2020November 25, 2020 Ubiq MySQL
update multiple columns in mysql

Sometimes you may need to update multiple columns in MySQL. Here is how to update multiple columns in MySQL.

Continue reading


How to Escape Single Quote, Special Characters in MySQL

November 24, 2020November 24, 2020 Ubiq MySQL
escape single quote special characters in mysql

Sometimes you may need to store string with single quote, double quote, backticks and special characters. Here is how to escape single quote, special characters in MySQL.

Continue reading


How To Change User to Superuser in PostgreSQL

November 24, 2020November 24, 2020 Ubiq PostgreSQL
how to change user to superuser in postgresql

Sometimes you may need to change user to superuser in PostgreSQL. Here is alter user to superuser in PostgreSQL.

Continue reading


Posts navigation

Older posts
Newer posts

About Us



Ubiq is a business intelligence & reporting tool for small & medium businesses. Build business dashboards, charts & reports in minutes.Try it Today!




  • Popular
  • Recent
  • transpose rows columns dynamically
    How to Transpose Rows to Columns Dynamically in MySQL Feb 12, 2020
  • calculate percentage of column in mysql
    How to Calculate Percentage of Column in MySQL Jan 6, 2020
  • calculate total sales per month in mysql
    How to Calculate Total Sales Per Month in MySQL? Mar 25, 2020
  • How to create a read-only MySQL user? Nov 25, 2013
  • get last record in each group
    How To Get Last Record In Each Group In MySQL May 27, 2020
  • calculate moving average mysql
    How to Calculate Moving Average in MySQL Feb 17, 2020
  • import csv to mysql workbench
    How to Import CSV to MySQL Workbench Apr 30, 2020
  • coalesce in mysql
    How to Use Coalesce in MySQL Jan 19, 2021
  • query json column in mysql
    How to Query JSON column in MySQL Jan 18, 2021
  • avoid inserting duplicate records in mysql
    How To Avoid Inserting Duplicate Records in MySQL Jan 18, 2021
  • update array in postgresql
    How to Update Array in PostgreSQL Jan 15, 2021
  • get multiple count in mysql
    How to Get Multiple Counts With Single Query in MySQL Jan 15, 2021
  • convert datetime to utc in mysql
    How to Convert datetime to UTC in MySQL Jan 14, 2021
  • how to insert into array in postgresql
    How to Insert into Array in PostgreSQL Jan 5, 2021
dazzling Theme by Colorlib Powered by WordPress