Category: DB
DB
What are Triggers?
This article provides an introduction to triggers and discusses the benefits and trade-offs of using them.
What are Triggers?Triggers are MySQL programs that are executed...
DB
EXPLAIN plan in SQL
This article demonstrates the usage of the EXPLAIN plan in SQL.
In this article, we'll make a brief introduction to the EXPLAIN statement. The EXPLAIN...
DB
How to use TRUNCATE for MYSQL
This article discusses how to delete all the rows of a table using the TRUNCATE clause.
In the previous article, we learned how to delete...
DB
View in SQL with example
We will learn about three different ways of creating views.
Views are virtual tables that are created as a result of a SELECT query. They...
DB
How to use multi-table delete in SQL
We know how to delete data from a single table, however, if you are confronted with a situation where you want to delete data...
DB
what are the different types of joins in SQL
This article discusses thedifferent types of joins in SQL as specified by ANSI SQL.
In the previous article, we worked with a single table to...