Freaks City

After a prolonged break from coding, I found myself struggling to recall basic SQL syntax 😅 Reviewing my old SQL notes and adding some updates 😂 Primary references: MySQL Documentation: https://dev.mysql.com/doc/refman/8.0/en/tutorial.html Yi Bai Tutorial: https://www.yiibai.com/mysql "Learning SQL" by Alan Beaulieu Basic Operatio ...

Query Parameters from fastapi import Query username: str = Query(..., title="User name", min_length=5, max_length=30) Detail Example Purpose Extracts values from the URL query string URL Pattern /items?username=alice Required/Optional Query(...) required; Query(None) optional Default role: str = Query("user") ...

1. String Concatenation Operator SELECT 'Employee: ' || ename || ', Role: ' || job || ', Salary: ' || sal AS details FROM emp; 2. Convert Strings to Lowercase SELECT LOWER(ename) AS lowercase_name FROM emp; 3. Value Replacmeent SELECT DECODE(deptno, 10, 'Development', 20, 'Product', 30, 'Maintenance') AS department FROM emp; 4. Extract Curre ...

MongoDB provides a wide range of operators for both simple queries and complex aggregation pipelines. The following comparison opertaors are frequently used with the find() method: $gt – greater than $lt – less then $gte – greater than or equal to $lte – less than or equal to $ne – not equal Example: fetch products with a stock count above 50 ...

LINQ (Language Integrated Query) provides a unified model for querying data across diverse sources. It integrates directly into C# without introducing a separate language. LINQ can be categorized functionally into LINQ to Objects for in-memory collections and LINQ to Providers for custom data sources like XML or JSON. Syntactically, it offers S ...

Attitude: Believe that victory is ahead. If you stop because of small issues, you might not be fit to win. The road to success is muddy, but in the end, the mud on you will be medals of honor! Today's motto: Everything that happens benefits me. Table of Contents SELECT Selecting All Columns Selecting Specific Columns Expressions in Queries ...