Month: January 2022

Stored Procedure in MySQL

A Stored procedure is a collection of pre-compiled SQL statements stored inside the database. A procedure always contains a name, parameter lists, and SQL statements. Stored Procedure increases the performance of the applications. Once stored...
READ MORE   >>

Views in MySQL

Views are virtual tables that do not store their own data but display all or a few rows of data stored in other tables. View helps to simplify the complex business logic written in the SQL queries to simple one. Syntax CREATE VIEW `view_name`...
READ MORE   >>

MySQL SELF JOIN

A SELF JOIN is a join that is used to join a table with itself. However, there is a need to combine data with other data in the same table itself. In that case, we use Self...
READ MORE   >>

MySQL CROSS JOIN

Cross JOIN is a simplest form of JOINs which matches each row from one database table to all   rows of another. In other words, it gives us combinations of each row of first table with all records in second table. Syntax SELECT...
READ MORE   >>

Recent Comments

    • Copyright © 2020 (Er. Shairy Kalra). All Rights Reserved