Tag: MySQL

All the articles with the tag "MySQL".

• How to Convert SQL Rows to a Comma-Delimited String in various RDBMSs

  Updated:Oct 24, 2024 |  at 08:40 PM

  In this article, we will explore how to achieve this in MySQL, Oracle, SQL Server, PostgreSQL, and SQLite.

• How to Implement CREATE TABLE IF NOT EXISTS in various RDBMSs

  Updated:Oct 24, 2024 |  at 08:20 PM

  Different databases handle conditional table creation in various ways. MySQL, PostgreSQL, and SQLite support the simple CREATE TABLE IF NOT EXISTS syntax directly.

• How to achieve STRING_AGG() in MySQL database

  Updated:Oct 24, 2024 |  at 01:29 AM

  STRING_AGG() alternatives in MySQL database.