CASE expression with Derived Table: Alternative combo for multiple row UPDATE.

In this blog post, we will leverage the CASE expression and a Derived Table for updating multiple rows within the same UPDATE statement.
(more…)

Advertisements

UPDATE and DELETE: Examples with MySQL – Beginner Series.

Continuing with the MySQL Beginner Series Basics, this blog post will briefly visit both the UPDATE and DELETE SQL Data Manipulation Commands. Be sure to visit the MySQL Categories folder in the sidebar for all the posts in the series so far.
(more…)

Discover PostgreSQL table data with SELECT statement.

Proceeding from Part 1 and Part 2 of this series, today’s post will involve reading stored data in a PostgreSQL table using the SELECT statement along with filtering criteria in the WHERE clause for specific record searches. Modifying table data with the UPDATE command will also be visited to round out this discussion.

(more…)