Dynamic column names SQL

Asked Aug 22 '18 at 22:57

Active Aug 22 '18 at 22:57

Viewed 69 times

I'm trying to do a query in such a way that column names change based on a variable.

I've tried doing something like

SELECT 1 AS (CASE WHEN ${x} >= 0 THEN `name1` ELSE `name2` END)

DEFINE MACRO c_name (CASE WHEN ${x} >= 0 THEN `name1` ELSE `name2` END)
SELECT 1 AS $c_name

How can I change the name of a column depending on a variable? The script should be able to run on MySQL, PostgreSQL, or some engine similar to those. The script should also not contain any "ALTER" Statements

asked Aug 22 '18 at 22:57

Camilo Andres Rosales Marraui

Does it have to be "pure" SQL or do you use some programming language to build your query and run it? – Nic3500 Aug 22 '18 at 23:05
You should check https://stackoverflow.com/questions/2727387/sql-server-variable-columns-name – juanbits Aug 22 '18 at 23:06
Possible duplicate of [mysql field name from variable](https://stackoverflow.com/questions/4428761/mysql-field-name-from-variable) – Erubiel Aug 22 '18 at 23:20
@Nic3500 yes, sadly it has to be pure sql – Camilo Andres Rosales Marraui Aug 23 '18 at 00:05
This cannot be done in pure SQL. SQL is not a procedural language with variables. You'll have to embed your SQL in a script or program that constructs the second statement based on the result of the first. – Laurenz Albe Aug 23 '18 at 06:24

Dynamic column names SQL

0 Answers0