All pages tagged with "MySQL"

How to round up numbers in MySQL database server

Learn how to round up numbers in your MySQL statements

Read More →

October 09, 2021

October 09, 2021

MySQL DISTINCT clause explained

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

Read More →

October 08, 2021

October 08, 2021

MySQL CURDATE function explained

Learn how MySQL CURDATE function works

Read More →

October 08, 2021

October 08, 2021

MySQL default port and how to change it

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

Read More →

October 07, 2021

October 07, 2021

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

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

Read More →

October 07, 2021

October 07, 2021

How to change MySQL root password

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

Read More →

October 06, 2021

October 06, 2021

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

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

Read More →

October 06, 2021

October 06, 2021

How to revoke privileges from your MySQL accounts

Learn how to revoke privileges from your MySQL accounts

Read More →

October 05, 2021

October 05, 2021

The MySQL TRIM() function explained

Learn how the MySQL TRIM() function works here

Read More →

October 04, 2021

October 04, 2021

How to rename MySQL table tutorial

How to rename an existing MySQL table in your database

Read More →

October 03, 2021

October 03, 2021

How to fix MySQL database ERROR 1054: Unknown column

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

Read More →

October 02, 2021

October 02, 2021

MySQL CAST() function explained

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

Read More →

October 02, 2021

October 02, 2021

How to split string value in MySQL query

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

Read More →

October 01, 2021

October 01, 2021

Understanding MySQL VARCHAR data type

Learn how MySQL VARCHAR data type works and its limitations

Read More →

September 30, 2021

September 30, 2021

How to write a comment in MySQL

Learn how to write comments in MySQL

Read More →

September 29, 2021

September 29, 2021

How to fix MySQL server PID file could not be found error

Learn ways to fix MySQL server PID file could not be found error

Read More →

September 28, 2021

September 28, 2021

MySQL divide numbers using the division operator

Learn how to divide numbers in MySQL query using the division operator

Read More →

September 27, 2021

September 27, 2021

MySQL AUTO_INCREMENT attribute explained

Let's learn about MySQL auto increment feature and how to add it to your table's column

Read More →

September 26, 2021

September 26, 2021

MySQL WEEKDAY() function explained

Let's learn how MySQL WEEKDAY() function works

Read More →

September 25, 2021

September 25, 2021

How to rename MySQL table column or field name tutorial

Learn how to you can write an SQL query that changes a MySQL column or field name

Read More →

September 24, 2021

September 24, 2021