Aki13promy

BigQuery MERGE Statement – Explained with Syntax & Use Cases BigQuery MERGE Statement – Explained 📘 What is BigQuery MERGE? The MERGE statement in BigQuery allows you to conditionally INSERT , UPDATE , or DELETE rows in a target table based on matching rows from a source table. It’s ideal for data synchronization, staging table merges, and incremental updates. 🖼️ Thumbnail Preview 🧪 Syntax Overview MERGE target_table AS T USING source_table AS S ON T.id = S.id WHEN MATCHED THEN UPDATE SET T.name = S.name WHEN NOT MATCHED THEN INSERT (id, name) VALUES (S.id, S.name); 🎯 Example Use Case MERGE dataset.inventory AS I USING dataset.new_arrivals AS N ON I.product_id = N.product_id WHEN MATCHED THEN UPDATE SET I.quantity = I.quantity + N...

Putrajaya Secret Garden – A Magical Night Park Experience Looking for a place to hang out at night? Whether it's an after-dinner stroll, a cozy date night, or weekend outing with the family, the Putrajaya Secret Garden offers a magical experience. Free to enter and lit with dreamlike lights, it transforms nighttime wanderings into peaceful escapes. This Putrajaya Night Park (Secret Garden) is perfect for couples, families, and photography lovers alike. Avatar-style “Tree of Souls” lighting sets a magical tone here. The garden glows with color: lights drape over trees, pillars shimmer, bushes pulse in soft hues. As the skies darken around 7pm, the pathways light up like something out of a fairytale. It’s peaceful, never too crowded, and the perfect blend of relaxation and visual delight. 📍 Location & Access ...

MySQL MERGE Concept & Alternatives Explained MySQL MERGE Concept & Alternatives MySQL MERGE is not directly supported as a single SQL command like in some other database systems (e.g. SQL Server or Oracle), but the concept can be implemented using a combination of INSERT , UPDATE , and DELETE statements. The MERGE approach is helpful for syncing two tables where data may need to be inserted, updated, or removed depending on conditions. When implemented manually, this requires crafting multiple SQL queries to simulate the behavior. Users should have SELECT, INSERT, DELETE , and UPDATE privileges on both tables used in the MERGE operation. 🔧 Three Logical Cases in a MERGE Operation Case 1 – INSERT If a row exists in the source table but not in the target table, use INSERT to add it to the target. Case 2 – DELETE If a row exists in the tar...

Hari Raya Aidilfitri 2022 – A Surprise Celebration Hari Raya Aidilfitri 2022 – Celebration Recap 🌙 After two long years of distancing and quiet festivities, Hari Raya Aidilfitri 2022 in Malaysia was a celebration like no other. The official announcement stunned the nation—it was set a day earlier than expected, on May 2 instead of May 3. Social media exploded as families rushed to prepare last-minute dishes, prayer outfits, and travel plans. The streets came alive, homes gleamed with lanterns and decor, and the joy of returning to tradition could be felt in every smile and salam exchanged. For many, this marked the first real balik kampung after lockdowns, and emotions ran high. ✨ What Made This Raya Truly Memorable? 🥘 Grand feasts of rendang, satay, ketupat, and lemang united families 👗 Baju Raya fashion made a bold return in vibrant colo...

Spicy Prawn Masala Recipe 🌶️ Introduction: A Fiery Seafood Favourite Craving something bold and brimming with spice? This Spicy Prawn Masala is a soul-satisfying dish that brings the heat and heart of South Indian kitchens right to your table. Inspired by weekend market hauls and cherished family memories, it’s the kind of recipe that turns ordinary prawns into a culinary celebration. Whether paired with fluffy basmati rice or soft naan, this dish is bound to impress seafood lovers and spice enthusiasts alike. 🧄 Ingredients 500g fresh prawns, cleaned and deveined 2 medium onions, finely chopped 2 tomatoes, pureed 1 tbsp ginger-garlic paste 2 green chillies, slit 1 tsp turmeric powder 1½ tsp red chilli powder 1 tsp coriander powder ½ tsp garam masala Salt to taste Fresh coriander leaves for garnish 2 tbsp oil 🍳 Preparation Heat oil in a pan and sauté the onion...

Welcome to AKI13pro – YouTube Channel Introduction 👋 Welcome to AKI13pro – My Simple Space Online This page is a friendly intro to my YouTube channel AKI13pro . I started this space to share day-to-day activities and personal adventures—from playing with my pets to relaxing hobbies like traveling, gardening, and cooking. I’m still exploring and learning, but every clip and story is real. If you enjoy simple, relatable content and real-life joy, I’d love to have you subscribe and be part of this journey. 📺 Where to Find Me YouTube Channel: AKI13pro – YouTube Dailymotion Channel: Aki13promy – Dailymotion 🎥 Watch My Intro Video 💡 What You'll Find 🐾 Pet interactions and animal care moments 🍳 Simple and fun home coo...