ubiq

Build dashboards & reports in minutes

  • Blog
  • What is Ubiq
  • Free Trial

MySQL

How to Use Coalesce in MySQL

January 19, 2021January 19, 2021 Ubiq MySQL
coalesce in mysql

Coalesce is a useful MySQL function that returns first non-null value. Here is how to use Coalesce in MySQL.

Continue reading


How to Query JSON column in MySQL

January 18, 2021January 18, 2021 Ubiq MySQL
query json column in mysql

Sometimes you may need to search JSON array of objects, extract JSON data or retrieve JSON data in MySQL. In this article, we will look at how to query JSON column in MySQL.

Continue reading


How To Avoid Inserting Duplicate Records in MySQL

January 18, 2021January 18, 2021 Ubiq MySQL
avoid inserting duplicate records in mysql

Sometimes you may need to prevent duplicate insert while adding rows. Here is how to avoid inserting duplicate records in MySQL.

Continue reading


How to Get Multiple Counts With Single Query in MySQL

January 15, 2021January 15, 2021 Ubiq MySQL
get multiple count in mysql

Sometimes you may need to select multiple count in one query or get multiple counts for different criteria. Here is how to get multiple counts with single query in MySQL.

Continue reading


How to Convert datetime to UTC in MySQL

January 14, 2021January 14, 2021 Ubiq MySQL
convert datetime to utc in mysql

Sometimes you may need to set timezone to UTC or change timezone to UTC. Here is how to convert datetime to UTC in MySQL

Continue reading


How to Convert UTC to Local Time in MySQL

January 1, 2021January 1, 2021 Ubiq MySQL
convert utc to local time in mysql

Sometimes you may need to change UTC to local time in MySQL. Here is how to convert UTC to local time in MySQL.

Continue reading


How to Get Current Date and Time in MySQL

December 21, 2020December 21, 2020 Ubiq MySQL
get current date and time in mysql

Sometimes you may need to get date from datetime, or get current datetime. Here is how to get current date and time in MySQL.

Continue reading


How to Group By Month in MySQL

December 16, 2020December 16, 2020 Ubiq MySQL
group by month in mysql

Sometimes you may need to aggregate by month in MySQL. Here is how to group by month in MySQL.

Continue reading


How to Remove Not Null Constraint in MySQL

December 14, 2020December 14, 2020 Ubiq MySQL
remove not null constraint in mysql

MySQL allows you to remove NOT NULL constraint in MySQL. Here is how to remove NOT NULL constraint in MySQL.

Continue reading


How to Remove Default Value of Column in MySQL

December 10, 2020December 10, 2020 Ubiq MySQL
remove default value in mysql

Sometimes you may need to remove default value in MySQL column. Here is how to remove default value of column in MySQL

Continue reading


Posts navigation

Older posts

About Us



Ubiq is a business intelligence & reporting tool that makes it easy to get insights from data. 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
  • check value in postgresql array
    How to Check if PostgreSQL Array Contains Value Jan 19, 2021
  • 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
dazzling Theme by Colorlib Powered by WordPress