Build dashboards & reports in minutes

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

MySQL

How To Alter Column From NULL to NOT NULL

June 16, 2025June 16, 2025 Sreeram Sreenivasan Leave a comment MySQL, PostgreSQL, SQL
null to not null

Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.

Continue reading


How to Import SQL File in MySQL

January 6, 2025January 6, 2025 Sreeram Sreenivasan Leave a comment MySQL
import sql file into mysql database

Sometimes database administrators need to import sql file in MySQL. Here are the different ways to do it.

Continue reading


How to Concatenate Multiple MySQL Rows into One Field

November 28, 2024November 28, 2024 Sreeram Sreenivasan Leave a comment MySQL
concatenate multiple mysql rows into one field

Often database programmers need to concatenate multiple MySQL rows into one field. Here is how to do this using group_concat() function.

Continue reading


How to See Foreign Keys Related to Table or Column

October 30, 2024October 30, 2024 Sreeram Sreenivasan Leave a comment MySQL
foreign keys related to table

Do you need to get list of foreign keys related to table or column in SQL? Here are the different ways to get foreign keys referencing table in MySQL.

Continue reading


How to Reset Auto Increment in MySQL

October 29, 2024October 29, 2024 Sreeram Sreenivasan Leave a comment MySQL
reset auto increment in mysql

Sometimes database developers need to reset auto increment column in MySQL. Here are different ways to set the auto increment value.

Continue reading


How to List Users in MySQL

October 28, 2024October 28, 2024 Sreeram Sreenivasan Leave a comment MySQL
list users in mysql

Database administrators need to determine the users in MySQL server. Here is how to list users in MySQL.

Continue reading


How to Get Character Set of MySQL database or table or column

October 23, 2024October 23, 2024 Sreeram Sreenivasan Leave a comment MySQL
get character set of mysql database table column

Often MySQL database administrators need to get character set of MySQL database, table or column. Here is how to do it.

Continue reading


How to Prevent SQL Injection Attack

September 18, 2024June 10, 2025 Sreeram Sreenivasan Leave a comment MySQL, PostgreSQL, SQL
prevent sql injection

It is important to protect your website from SQL injection attack. Here are the steps to prevent SQL Injection (SQLi).

Continue reading


How to MySQLDump Only Specific Tables

September 11, 2024June 10, 2025 Sreeram Sreenivasan Leave a comment MySQL
mysqldump specific tables

Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.

Continue reading


Difference Between InnoDB vs MyISAM

July 31, 2024June 10, 2025 Sreeram Sreenivasan Leave a comment MySQL
innodb vs myisam

Here is the detailed difference between InnoDB vs MyISAM storage engines in MySQL database system.

Continue reading


Posts navigation

Older posts

About Us



Ubiq is a business intelligence & reporting tool for small & medium businesses. Build business dashboards, charts & reports in minutes. Get insights from data quickly. Try it for free!




Data Reporting
  • MySQL Charts
  • MySQL Visualization Tool
  • Create Graph from MySQL Database
  • MySQL Report Builder
  • MySQL Report Maker
  • PostgreSQL Reporting Tools
  • MySQL Report Writer
  • SQL Reporting Tools
Business Intelligence
  • BI Solution
  • Online Business Intelligence
  • Online Reporting Software Tool
  • SaaS BI
  • MIS Reporting
Data Visualization
  • Data Analysis Tool
  • Data Visualization Tools
Dashboards
  • Dashboard Builder
  • Dashboard Reporting Software Tool
  • MySQL Dashboard Builder
  • Online Report Generator
  • Customer Service Dashboard
  • Insurance Dashboard
  • Retail Dashboard
  • Dashboard Creator
  • Online Dashboard
Quicklinks
  • Contact Us
  • Docs
  • Tech Blog
Resources
  • Security
  • Privacy
  • T&C
  • Sitemap
dazzling Theme by Colorlib Powered by WordPress