Articles related to core DBMS topics such as normalization, DDL & DML statements, ACID properties, different databases, etc.
You can temporarily disable a foreign key constraint in MySQL by using the SET FOREIGN_KEY_CHECKS variable. To disable a foreign key constraint, you can use the following statement: SET FOREIGN_KEY_CHECKS…
Summary: In this tutorial, you will learn about dependencies and its types in context to relational databases (DBMS) with the help of the examples. Dependencies in DBMS In a database…
Summary: In this tutorial, you will learn to store hashed passwords into the MySQL database with the help of examples. It is generally not a good idea to store plaintext…
Summary: In this tutorial, we will learn what is normalization and what is its purpose in DBMS. In addition, we will also look at different types of normal forms (such…
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…
Summary: In this tutorial, we will learn to update a table in MySQL using the UPDATE TABLE statement. Introduction to MySQL UPDATE statement The UPDATE statement in MySQL updates existing…
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.…
Summary: In this tutorial, we will learn how to use MySQL INSERT INTO statement to insert records into a MySQL table along with examples. Introduction to MySQL INSERT INTO statement…
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…
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…