Latest Topics from MySQL Tutorial
MySQL vs MongoDB Comparison
In this tutorial, we'll compare MySQL vs MongoDB, the two most popular…
Concatenate Strings in an SQL Query With Examples
Understanding how to merge or join strings together in SQL is crucial…
The Difference between UPSERT & INSERT in MySQL
In MySQL, you might wonder what's the difference between UPSERT and INSERT…
SQL Programming Test
Welcome to this amazing SQL programming test that will help anyone deeply…
How to CREATE a TABLE in SQL
SQL table creation is a database operation that creates a new table…
How to Create a User with Password in MySQL
This tutorial explains how to create a user with a password in…
MySQL CURRENT_TIMESTAMP() Function
This tutorial explains how to use the MySQL CURRENT_TIMESTAMP() function with the…
How does MySQL differ from PostgreSQL?
This tutorial explains MySQL vs PostgreSQL, i.e., the difference between MySQL and…
Grant Privileges on a Database in MySQL
This tutorial explains how you can grant privileges on a database in…
MySQL FROM_UNIXTIME() Function
This tutorial explains how to use the MySQL FROM_UNIXTIME() function with the…
MySQL UPSERT Explained with Examples
Imagine you’re adding records to your MySQL table—but sometimes the row exists,…
MySQL Date and Date Functions
This tutorial explains MySQL DATE data type and walks you through some…
MySQL LOWER() and LCASE()
This tutorial explains MySQL LOWER()/LCASE() functions which convert the upper case characters…
MySQL UPPER() and UCASE() Functions
This tutorial explains MySQL UPPER()/UCASE() functions which convert the lowercase characters of…
MySQL ORDER BY with Simple Examples
This tutorial explains MySQL ORDER BY clause and its usage with both…
MySQL Data Types Explained
This tutorial explains all MySQL data types, their characteristics, and min, max…
MySQL TIMESTAMP with Examples
This tutorial explains MySQL TIMESTAMP and TIMESTAMP field characteristics such as automated…
MySQL Insert Statement to Add Rows
This tutorial explains the MySQL INSERT command to insert single and multiple…
MySQL Aggregate Functions
This tutorial explains the use of MySQL aggregate functions like AVG, COUNT,…
MySQL OPTIMIZE TABLE Statement
This tutorial explains MySQL OPTIMIZE TABLE statement which defrags tables and recovers…