All MySQL Tutorials

How to fix MySQL ERROR code 1175 safe update mode

Tag: MySQL

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

The MySQL ENUM data type explained

Tag: MySQL

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

The MySQL BIT data type explained

Tag: MySQL

Learn how the BIT data type works in MySQL

MySQL - How BOOLEAN data type works

Tag: MySQL

Learn how to implement BOOLEAN data type in MySQL

MySQL DECIMAL data type explained

Tag: MySQL

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

How to solve MySQL can't reopen table error

Tag: MySQL

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

How to round up numbers in MySQL database server

Tag: MySQL

Learn how to round up numbers in your MySQL statements

MySQL DISTINCT clause explained

Tag: MySQL

Learn how MySQL DISTINCT clause works and when you should use it

MySQL CURDATE function explained

Tag: MySQL

Learn how MySQL CURDATE function works

MySQL default port and how to change it

Tag: MySQL

Learn the default port used by MySQL server and how to change it

How to fix MySQL ERROR 1396 - CREATE or DROP USER failed

Tag: MySQL

Learn how to fix MySQL ERROR code 1396 related to creating and removing users account

How to change MySQL root password

Tag: MySQL

Let's learn how you can change your MySQL root password

How to fix MySQL operand should contain 1 column(s) error

Tag: MySQL

Learn how to fix MySQL error operand should contain 1 column(s)

How to revoke privileges from your MySQL accounts

Tag: MySQL

Learn how to revoke privileges from your MySQL accounts

The MySQL TRIM() function explained

Tag: MySQL

Learn how the MySQL TRIM() function works here

How to rename MySQL table tutorial

Tag: MySQL

How to rename an existing MySQL table in your database

How to fix MySQL database ERROR 1054: Unknown column

Tag: MySQL

Learn how to fix ERROR 1054: Unknown column from your MySQL database

MySQL CAST() function explained

Tag: MySQL

Learn how MySQL CAST() function can help you convert value types

How to split string value in MySQL query

Tag: MySQL

Learn how to split string values in MySQL with the help of the SUBSTRING_INDEX function

Understanding MySQL VARCHAR data type

Tag: MySQL

Learn how MySQL VARCHAR data type works and its limitations