Author Prasi
Altering and Managing Views: View for frequently selecting columns: With check option to view only virtual table: View not updatable: Real-world Examples of Views in MySQL Creating Simple Views Create a view called emp_sal on the myemp table by selecting… Continue Reading →
Truncate vs delete: 2 types of Insert into students table: Create a students table with following fields and constraints. 4 types of constraints while creating table: Update multiple records: Update exercise: Mode of working Update cmd: Querying schema: Inner Join:… 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: Date: Executing SQL Statements: Step:1 Create a table called countries… 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 →