Let's learn something new

How to store array data type in MySQL

A quick guide on storing array data type using MySQL database server

Read More →

October 26, 2021

October 26, 2021

How to change the limit of MySQL GROUP_CONCAT function

Learn how to change the limit of MySQL GROUP_CONCAT function

Read More →

October 25, 2021

October 25, 2021

The MySQL SUM() function explained

Learn how the SUM function works in MySQL database server

Read More →

October 24, 2021

October 24, 2021

How to fix MySQL incorrect datetime value error

Learn how to fix MySQL incorrect datetime value error in this tutorial

Read More →

October 23, 2021

October 23, 2021

The easiest way to find the median value in MySQL database server

Learn how to calculate median value in a MySQL table column with example query included

Read More →

October 22, 2021

October 22, 2021

The MySQL DATE_ADD() function explained

Learn how the MySQL DATE_ADD function works here

Read More →

October 21, 2021

October 21, 2021

How to fix MySQL invalid use of group function error

Learn how to fix MySQL ERROR 1111: Invalid use of group function

Read More →

October 20, 2021

October 20, 2021

MySQL TIMESTAMPDIFF() function explained

Learn how TIMESTAMPDIFF function works in MySQL database server

Read More →

October 19, 2021

October 19, 2021

Python and MySQL Error: No module named mysql

Learn how to fix the ImportError: No module named mysql in Python scripts

Read More →

October 18, 2021

October 18, 2021

The MySQL DAYOFWEEK() function explained

Learn how DAYOFWEEK() function works in MySQL database server

Read More →

October 17, 2021

October 17, 2021

How to uninstall MySQL Workbench on macOS

Learn how to uninstall MySQL Workbench on macOS and remove its application data

Read More →

October 16, 2021

October 16, 2021

How to enable MySQL Workbench dark theme (Windows, macOS, Linux)

Learn how to enable MySQL Workbench dark theme on Windows, macOS, and Linux

Read More →

October 15, 2021

October 15, 2021

How to generate random strings in MySQL

Learn how to generate random strings in MySQL

Read More →

October 14, 2021

October 14, 2021

The MySQL DATEDIFF() function explained

Learn how to count day differences using the DATEDIFF function

Read More →

October 13, 2021

October 13, 2021

How to fix MySQL ERROR code 1175 safe update mode

Learn how to fix MySQL ERROR code 1175 in the command line and MySQL Workbench

Read More →

October 13, 2021

October 13, 2021

The MySQL ENUM data type explained

Learn how the ENUM data type works in MySQL and when you should use it

Read More →

October 12, 2021

October 12, 2021

The MySQL BIT data type explained

Learn how the BIT data type works in MySQL

Read More →

October 11, 2021

October 11, 2021

MySQL - How BOOLEAN data type works

Learn how to implement BOOLEAN data type in MySQL

Read More →

October 11, 2021

October 11, 2021

MySQL DECIMAL data type explained

Learn how MySQL DECIMAL data type works and when you should use it

Read More →

October 10, 2021

October 10, 2021

How to solve MySQL can't reopen table error

Learn how to solve MySQL can't reopen table issue for a temporary table

Read More →

October 09, 2021

October 09, 2021