Category Technology

Check the table in cmd: If-elseif-else: Loops: Simple_loop static: Simple loop dynamic: Stored procedure without parameter: Stored procedure with parameter: Local and Session variables: Local parameter: Simple procedure practice:

Exception handling: Exception handlers: Continue handler: Exit handler: Single error handler: Multiple errors multiple handlers SQL exception: Control flow Explanation of the code Shipped Status                         Cancelled Status                     On Hold Status Application to identify the fraud: Create procedure for payments table:… Continue Reading →

Altering and Managing Views: View for frequently selecting columns: With check option to view only virtual table: View not updatable: Real-world Examples of Views in MySQL Creating Simple Views Create a view called emp_sal on the myemp table by selecting… Continue Reading →

Truncate vs delete: 2 types of Insert into students table: Create a students table with following fields and constraints. 4 types of constraints while creating table: Update multiple records: Update exercise: Mode of working Update cmd: Querying schema: Inner Join:… Continue Reading →

A Step-by-Step Guide to Learning Structured Query Language Setting Up Your MySQL Environment Day:1 – create a database called ‘assignments’ Create the tables and Enter the records Understanding Database Concepts: Date: Executing SQL Statements: Step:1 Create a table called countries… Continue Reading →