Simple Recipe - Prawn Cooking

-


Comments

Post a Comment

Popular posts from this blog

Night Park Putrajaya - Secret Garden

-
Image
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 ...
Read more

BigQuery MERGE Statement – Explained

-
Image
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...
Read more

PostgreSQL ON CONFLICT Statement

-
PostgreSQL ON CONFLICT Statement - Explained PostgreSQL ON CONFLICT Statement - Explained 📘 Introduction to ON CONFLICT Statement In PostgreSQL, ON CONFLICT provides a powerful mechanism to deal with data clashes during INSERT operations. When inserting into a table that contains a UNIQUE constraint or index, you can define how the database should react—either by updating the existing record or ignoring the new one. 🧪 Syntax Overview INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...) ON CONFLICT (conflict_target) DO UPDATE SET column1 = value1, column2 = value2, ...; conflict_target: typically the column(s) with a UNIQUE constraint (e.g., employee_id) DO UPDATE: specifies what should be updated DO NOTHING: skips the insertion if conflict occurs ...
Read more