Database Management Systems DBMS Lab PCCSL408 Semester 4 KTU CS 2024 Scheme

 About Me

Scheme and Syllabus

Experiments






Build a web application based on sample database- use Php-MySQL

Comments

Post a Comment

Popular posts from this blog

Stored Procedures in MySQL

  CREATION OF STORED PROCEDURES IN MySQL 1. AIM To study and implement Stored Procedures in MySQL. 2. THEORY ✔ What is a Stored Procedure? A Stored Procedure is a precompiled block of SQL statements stored in the database and executed on demand. ✔ Advantages of Stored Procedures Improves performance (precompiled) Ensures reusability of code Helps maintain data integrity Reduces network traffic Provides security by restricting direct table access 3. GENERAL SYNTAX (MySQL) MySQL requires the DELIMITER command when creating procedures to avoid conflict with semicolons. DELIMITER $$ CREATE PROCEDURE procedure_name (parameter_list) BEGIN SQL statements; END $$ DELIMITER ; ✔ Calling a Procedure CALL procedure_name(arguments); 4. EXAMPLES  ⭐ Example 1: Procedure Without Parameters ▶ Create a table for demonstration CREATE TABLE employees ( id INT PRIMARY KEY, name VARCHAR ( 100 ), salary DECIMAL ( 10 , 2 ) ); ▶ Inse...
Read more

Cursors in MySQL

  IMPLEMENTATION OF CURSORS  IN MYSQL 1. AIM To understand the concept of cursors in MySQL and implement them inside stored procedures with examples. 2. THEORY ✔ What is a Cursor? A cursor in MySQL is a database object used to retrieve and process query results row-by-row . Normally, SQL works in a set-oriented way (all rows at once). But sometimes you need record-by-record processing , such as: Calculating values per row Generating summaries Performing row-by-row validations Creating logs for each row This is where cursors are useful. 3. CURSOR COMPONENTS To use a cursor in MySQL, you need: ✔ 1. Declare variables Used to store individual column values from each row. ✔ 2. Declare a cursor Specifies the SELECT query whose rows you want to process. DECLARE cursor_name CURSOR FOR SELECT query; ✔ 3. Declare a CONTINUE HANDLER This handles the situation when the cursor reaches the end. DECLARE CONTINUE HANDLER FOR NOT FOUND SET finishe...
Read more