Month August 2023
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 →