This set of guides will walk you through how to integrate control flow into SQL scripts to generate dynamic output.
This guide walks through the syntax needed to implement aliases in SQL queries to help with cleaning up column names in a result set. Additionally, we'll walk through how to export query data to a CSV file in MySQL Workbench.
This guides provides the syntax for assigning alias names to tables in SQL. Additionally, we'll discuss when table name aliases are practical to use.
In this lesson you'll learn how to implement case statements in SQL in order to dynamically add labels to a result set based on conditional logic. Specifically, we'll add the ability for queries to return a new column that contains a status based on revenue.
devCamp does not support ancient browsers.
Install a modern version for best experience.