Skip to content
Tagged articles

user-defined functions

2 articles · Page 1 of 1

Wallet, Pre-Made Meals & Calculators: Master Database Triggers, Procedures & Functions

This article explains MySQL triggers, stored procedures, and user-defined functions using relatable analogies—a wallet for triggers, pre-made meals for procedures, and a custom calculator for functions—complete with syntax templates, practical code examples for automated data logging, batch revenue calculation, and tiered commission logic, plus a selection guide for choosing the right tool.

MySQLSQLautomated logging
0 likes · 11 min read
Wallet, Pre-Made Meals & Calculators: Master Database Triggers, Procedures & Functions
Big Data Technology & Architecture
Big Data Technology & Architecture
Mar 19, 2019 · Big Data

Comprehensive Overview of SQL and Apache Flink SQL Features with Practical Code Examples

This article provides an in-depth introduction to SQL, its history and ANSI standards, then details Apache Flink's SQL capabilities—including SELECT, WHERE, GROUP BY, UNION, JOIN, window functions, and user-defined functions—accompanied by extensive code examples and a complete end‑to‑end Flink job implementation.

Apache FlinkSQLWindow Functions
0 likes · 34 min read
Comprehensive Overview of SQL and Apache Flink SQL Features with Practical Code Examples