Run MySQL Database with Docker

This tutorial will show you how to setup and run MySQL database with Docker. MySQL is the world’s most popular open source database. MySQL database is available in community and Enterprise edition. We can install MySQL community edition on our systems by downloading corresponding installation files from official website. Instead of installing as native application…

How to use string_agg function in PostgreSQL with examples

In this blog post, I will show the usage of string_agg function in PostgreSQL with examples. As name suggests, string_agg is a string aggregate function which is used to concatenate values from multiple rows into one. Syntax Usage Lets first create a user table to show the usage. put some data into the table Below…