All pages tagged with "MySQL"

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

MySQL - How to get the current date from your query

Learn how to get the current date and time from MySQL database server

Read More →

September 23, 2021

September 23, 2021

MySQL - How to count duplicate entries in your database

Create an SQL query that counts how many duplicates exist in your MySQL table

Read More →

September 22, 2021

September 22, 2021

How to fix MySQL connect to server at localhost failed error

Learn how to fix MySQL connect to server at localhost failed error

Read More →

September 21, 2021

September 21, 2021

How to fix MySQL command not found error

Learn how to fix MySQL command not found error in Windows, macOS, and Linux

Read More →

September 20, 2021

September 20, 2021

How to SELECT only the first row in a MySQL table

Learn how to make MySQL return only the first row in a SELECT statement

Read More →

September 19, 2021

September 19, 2021

How to copy or clone a MySQL database

Learn how to create a database copy in MySQL platform

Read More →

September 18, 2021

September 18, 2021

The MySQL IF ELSE statement explained

Learn how to create conditional MySQL functions and stored procedures with the IF statement

Read More →

September 17, 2021

September 17, 2021

The MySQL IF() function explained

Learn how to create conditional MySQL query with IF function

Read More →

September 16, 2021

September 16, 2021

The MySQL ISNULL() Function explained

This tutorial will explain how MySQL ISNULL function works

Read More →

September 15, 2021

September 15, 2021

The MySQL IFNULL() Function explained

This tutorial will explain how MySQL IFNULL() function works and when you should use it

Read More →

September 14, 2021

September 14, 2021

How to fix MySQL can't connect to server on localhost (10061) error

Learn how to fix MySQL error can't connect to the server

Read More →

September 13, 2021

September 13, 2021

How to fix --secure-file-priv option error

Learn how to fix --secure-file-priv option error and run import/ export data statements

Read More →

September 12, 2021

September 12, 2021

How to write MySQL query with not equal operator

Learn how to write MySQL query with not equal operator

Read More →

September 11, 2021

September 11, 2021

SQLite vs MySQL - Learn the differences between the two SQL database applications

Learn the differences between SQLite and MySQL database applications

Read More →

September 10, 2021

September 10, 2021

Fixing lost connection to MySQL server during query error

Learn how to fix lost connection to MySQL server during query error

Read More →

September 09, 2021

September 09, 2021

How to get the number of records or rows in a table using MySQL

Learn how to find the number of rows stored in a single MySQL database table

Read More →

September 08, 2021

September 08, 2021