Author Prasi
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 →
Now, joy is born of parents poor,And pleasure of our richer kind;Though pleasure’s free, she cannot singAs sweet a song as joy confined. Pleasure’s a Moth, that sleeps by dayAnd dances by false glare at night;But Joy’s a Butterfly, that… Continue Reading →
Two roads diverged in a yellow wood,And sorry I could not travel bothAnd be one traveler, long I stoodAnd looked down one as far as I couldTo where it bent in the undergrowth; Then took the other, as just as… Continue Reading →
We could leave the Christmas lights up ’til JanuaryAnd this is our place, we make the rulesAnd there’s a dazzling haze, a mysterious way about you dearHave I known you 20 seconds or 20 years?Can I go where you go?Can… Continue Reading →
A – Atomicity – attention to the details C – Consistency – Consistent improvement in whatever we do I – Isolation – Switch off the worlds noise D – Durable – Sustainably carrying out the activities for a long term… Continue Reading →