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 →

Base table—–> view table—> DML operations(insert, update and delete) Select statement directly from the base tableNot all views are used for insert update and deleteBut updatable only on direct selection from the columnsHide certain columns by selecting a portion of… Continue Reading →

Truncate vs delete: Types of insert: Constraints: 4 types of constraints while creating table: Create a students table with following fields and constraints. Update multiple records: Update exercise: Mode of working Update cmd: Find all employees who were hired after… 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: DDL commands by alter and drop : DML commands: In… Continue Reading →