mysql – Dynamic column alias

by

The answer is simple: It is not possible in SQL. Column aliases are constants. You would have to create the query dynamically to achieve what you want:

SET @column_alias1 := NOW() - INTERVAL 1 WEEK;
SET @column_alias2 := NOW() - INTERVAL 2 WEEK;
SET @query := CONCAT('SELECT SUM(...) AS `', @column_alias1, '`, SUM(...) AS `', @column_alias2, '` FROM ...');
PREPARE dynamic_statement FROM @query;
EXECUTE dynamic_statement;

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. SQL select only rows with max value on a column [duplicate]
  3. Get records with max value for each group of grouped SQL results
  4. MYSQL OR vs IN performance
  5. SELECTING with multiple WHERE conditions on same column
  6. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  7. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  8. How to find gaps in sequential numbering in mysql?
  9. MySQL: Invalid use of group function
  10. Combining UNION and LIMIT operations in MySQL query
  11. MySQL: View with Subquery in the FROM Clause Limitation
  12. MySQL comparison with null value
  13. Matching all values in IN clause
  14. MySql export schema without data
  15. INTERSECT in MySQL
  16. How do I get the ID of multiple inserted rows in MySQL?
  17. limiting the rows to where the sum a column equals a certain value in MySQL
  18. MySql Transpose Row into Column and Column into Row [duplicate]
  19. MySQL Inner Join Query Multiple Tables
  20. How to select column names dynamically in mySQL
  21. sql join tables where 1 column has comma
  22. Remove special characters from a database field
  23. MySQL LEFT JOIN 3 tables
  24. sql like operator on integer
  25. How to select data where a field has a min value in MySQL?
  26. How to SELECT by MAX(date)?
  27. The best way to remove value from SET field?
  28. get a recursive parent list
  29. #1060 – Duplicate column name ‘id’
  30. Update multiple rows with multiple ‘where’ clauses for each individual row

Leave a Comment