What are TCL Commands in SQL?
Before we dive deeper into the article (TCL commands in SQL), let's quickly go over the list of topics listed under the table of contents (TOC) that we will cover in...
Tag: MySQL
What are DCL Commands in SQL?
by Vikram Singh
LAST UPDATED: September 21, 2023, 11:18 IST
Before we dive deeper into the article (DCL commands in SQL), let's quickly go over the list of topics listed under the table of contents (TOC) that we will cover...
MariaDB vs MySQL – What’s the Difference?
LAST UPDATED: December 7, 2022, 16:57 IST
The main difference between MariaDB vs MySQL is that MariaDB is relatively faster than MySQL and does not support data masking and dynamic column. On the other hand, MySQL is...
Difference Between UNION and UNION ALL
by Vikram Singh
LAST UPDATED: June 23, 2023, 11:03 IST
UNION and UNION ALL in SQL are set operators that combine the result of two SELECT queries. Both share standard features, with one significant difference: UNION only returns a unique...
Cross Join in SQL
by Vikram Singh
LAST UPDATED: March 31, 2023, 16:41 IST
In the previous articles, we have discussed different types of Joins in SQL, such as Inner Join, Left Join, and Right Join. This article will discuss another type of SQL Join, i.e., Cross Join....
SQL Tutorial : Basic to Advance
by Vikram Singh
LAST UPDATED: June 23, 2023, 10:34 IST
SQL stands for Structured Query Language and is the most advanced and powerful tool for Relational Database Management Systems. It is specifically designed to Create, Read, Update, and Delete (CRUD) the data in...
SQL RIGHT JOIN – Example and Syntax
by Vikram Singh
LAST UPDATED: March 31, 2023, 16:40 IST
In the previous articles, we have briefly discussed left join and inner join in SQL with the help of examples. Now, in this article, we will discuss another type of join in SQL, i.e.,...
How to use DROP command in SQL?
by Vikram Singh
LAST UPDATED: June 21, 2023, 17:22 IST
In the previous article, we have discussed how to remove the data from the existing table using SQL TRUNCATE and SQL DELETE command. Now in this article, we will again...
How to use GROUP BY in SQL?
by Vikram Singh
LAST UPDATED: March 31, 2023, 16:40 IST
In the previous article, we have discussed SELECT statement, ORDER BY, HAVING clause, and aggregation functions in SQL. Now, in this article, we will discuss how to group the identical...
SQL ALTER TABLE : ADD, DROP, MODIFY, RENAME
by Vikram Singh
LAST UPDATED: March 31, 2023, 16:39 IST
In the previous article, we discussed how to create a table, update the record, and avoid duplicates in the table. Now, what if you want to change the structure of...