Home / Questions / 25218
Accepted
Katz
Asked: 2020-09-28 10:17:12 +0800 CST 2020-09-28 10:17:12 +0800 CST

How can I create a temporary row in MySQL

  • 772

Hello, I'm trying to make a temporary row in mysql but I can't do it, if I can do it how to create a column but I don't know how to make a row. Can somebody help me?

This is the original column

 _________________                 ______________      
|   Salario       |               |    AVERAGE   |
 _________________                |____________  |
|   200.000       |               |85585.714286  |
| ________________|               |______________|

^------- This is the original result

what i tried

This is the desired result --------------------------^

What I tried was:select "Average Salary", avg(salary) from EMP_DATA;

and create this

+----------------+--------------+
| Average Salary | avg(salary)  |
+----------------+--------------+
| Average Salary | 85585.714286 |
+----------------+--------------+

I was able to do the column but that's not what I want to do. I want the value of avg(salary)this below Average Salary like so:

+----------------+
| Average Salary | 
+----------------+
| 85585.714286   | 
+----------------+
mysql

2 Answers

  1. Best Answer

    Apparently you're trying to alias the column?:

    SELECT avg(salary) AS `Average Salary`
FROM EMP_DATA;
    • 3

  2. That is not a temporary row, it is a field that you include in your query, temporary tables can be made, but that is from transact sql, what the alias does is give a more understandable name to the column.

    • 1