mysql - 在Mysql中更改属性名称

Question

这是我原来的表格。

+----------+---------------------+--------+------------+-------+
| lab_code | test_name           | sample | time_taken | price |
+----------+---------------------+--------+------------+-------+
| FBS      | Fasting blood Suagr | Blood  | 01:15:00   |   400 |
| STLC     | Stool Culture       | Stool  | 48:00:00   |   700 |
| UA       | Urinalysis          | Urine  | 02:30:00   |   425 |
| UDS      | Urine drug screen   | Urine  | 06:00:00   |   550 |
+----------+---------------------+--------+------------+-------+

我要展示

+----------+
| Hospital | 
+----------+
| FBS      | 
| STLC     | 
| UA       | 
| UDS      | 
+----------+

我想在数据查询时更改属性名称。(不更改原始表)请帮助。

Answer 1

为特定列提供 ALIAS 名称

SELECT lab_code AS Hospital 
From tableA