Month August 2023
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 →
TO MY ONE AND ONLY STARBUCKS As I sit here with a warm cup of coffee, my heart bursts with love and thankfulness for the great journey we’ve gone on together. Our shared love of coffee, particularly those delectable Starbucks… Continue Reading →
I can’t believe August 7, 2022(Friendship day) was exactly one year since our fantastic first trip together. “One Year Later: The Impact of Sirumalai on Our Lives”( WHERE LOVE FOUND US) Do you recall the beginning of it all? We… Continue Reading →
Rediscovering Love’s Essence: For starters, let me start with the fact that I miss the way you treated me when we first started talking. Due to the fact that, in the beginning It thrilled my heart to know that I… Continue Reading →