Articles related to core DBMS topics such as normalization, DDL & DML statements, ACID properties, different databases, etc.

Why is Truncate faster than Delete?

The TRUNCATE TABLE statement is faster and more efficient than the DELETE statement in SQL databases. This is because TRUNCATE TABLE is a DDL command, unlike DELETE it does not…

0 Comments

Joins in MySQL

Summary: In this tutorial, we will learn what are Joins in MySQL, what are the different types of MySQL Joins and how and when to use different joins in MySQL.…

0 Comments

Temporary Table in MySQL

Summary: In this post, we will discuss everything about the MySQL Temporary table. Introduction to MySQL Temporary Table A temporary table in MySQL is a special type of table which…

0 Comments

MySQL Data Types

In this post, we will discuss all MySQL Data Types along with their properties, so that at the time of designing a new database, we would be able to use…

0 Comments

How to Rename Table in MySQL?

Summary: In this post, we will learn how to rename an existing table using the MySQL RENAME TABLE statement in MySQL. Introduction to RENAME TABLE The general syntax to rename…

0 Comments