Tag SQL commands for beginners
Creating triggers: Before insert trigger: To Create before insert trigger to make sure any new value of Working hours, if it is negative, then it should be inserted as positive. — Create the table create table emp_bit(name varchar(55),occupation varchar (100),working_date… Continue Reading →
Step-1: In this stored procedure, we declare a cursor variable cur that retrieves the names and marks columns from the marks table. Step-2: We also declare variables input_name, input_marks, to store the values fetched from the cursor Step-3: Inside the… Continue Reading →
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 →